Search results for query: *

I see. But the problem above doesnt appear again after I realloc a hdbc.

Is there someone know?

My SQL is "select * from table" Should the Cursor be a single cursor?

It's from ODBC Programming perferance: To execute a SELECT statement more than once, the application must call SQLCloseCursor before reexecuting the SELECT statement. So i think it's not necessary to free the Stmt.

To teriviret I think it should have no effect. SQLFreeStmt with SQL_CLOSE just close the cursor on last record set. I tried free the hDbc, and realloc, it works.

I want to place the SQL script maked by SQL Server Analyser into a c program, but a SQL statement can not include more than one statement as "Create Procedure", is there any way to execute a SQL batch include more than one "Create Procedure" statement?

For Tag vlan management, which table should use? I have read RFC2674, but I can not find it.

To execute a SELECT statement more than once, the application must call SQLCloseCursor before reexecuting the SELECT statement. SQLFreeStmt with option SQL_CLOSE is equal to SQLCloseCursor.

Thank you for your great patientness. But i know how odbc works, my problem is why the SQLFetch cannt step out, what's the reason, how to resolve it? perhaps you dont know my real mean, please see my follow code: bool Proc_SetVlanTB(ODBC_Handle& vOdbcHandle, UINT_32_T vNeID,SetVlanReq_Para*...

IonFilipski,Thank you! I have try your idea using SQLExecute instead of SQLExecDirect, but the problem is still there: after my second SQLExecute, in my SQLFetch circle, I cannt fetch all record, after i fetch the nth record(yestoday n is 9, today it's 37), the (n+1) fetch cannt step out--the...

Thanks for teriviret! I think it's because of exception too. But how to resolve this problem?

Thanks for fruNNik! I'll have a try

code: rc = SQLFreeStmt(odbcHandle.hStmt, SQL_CLOSE); rc = SQLExecDirect(odbcHandle.hStmt, (unsigned char*) sqlCommand,SQL_NTS); if(HasSqlError(odbcHandle, rc, ExecDirect, sqlCommand)) { DebugMsg("SQLExecDirect fail when get all vlan record"); return false; }...

how to place TCheckBox in TListView? In a ListView of vsReport, I want a column implemented by TCheckBox? Is it possible? If not, which other is good way to implement this?

Thank Svanels very much!

Can reinstall the ms c++ do efficiency? Because those problems havent appear before, while error do debug can pass.

My computer have install the sp4, but still cannt find file example for "MEMSET.ASM" , what should i do?

Thanks

Thanks for you! I'll have a try.

To Simon: Thanks for your idea! Bde cannt read SQL Server binary fields? But how do i use ADO instead?