Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smilife

    why exit when call SQLFetch?

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

    Which table should use for Tag vlan?

    Is there someone know?
  3. smilife

    why exit when call SQLFetch?

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

    why exit when call SQLFetch?

    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.
  5. smilife

    why exit when call SQLFetch?

    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.
  6. smilife

    How to execute a batch included more than one piece of "Create Proc"?

    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?
  7. smilife

    Which table should use for Tag vlan?

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

    why exit when call SQLFetch?

    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.
  9. smilife

    why exit when call SQLFetch?

    ...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* vpParam) { char sqlCommand[1024], VlanName[32]; ODBC_Handle odbcHandle = {mm_ReadOdbcHandle.hDbc, 0}; RETCODE rc; bool ret; bool VlanExist = false...
  10. smilife

    why exit when call SQLFetch?

    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...
  11. smilife

    why exit when call SQLFetch?

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

    How to place TCheckBox in Column of TListView? or similar way?

    Thanks for fruNNik! I'll have a try
  13. smilife

    why exit when call SQLFetch?

    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; }...
  14. smilife

    How to place TCheckBox in Column of TListView? or similar way?

    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?
  15. smilife

    how to read field of Binary[n] in SQL Server Table by TQuery?

    Thank Svanels very much!
  16. smilife

    why cannt find file 'dbgheap.c' while debug on program error?

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

    why cannt find file 'dbgheap.c' while debug on program error?

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

    how to read field of Binary[n] in SQL Server Table by TQuery?

    Thanks
  19. smilife

    how to read field of Binary[n] in SQL Server Table by TQuery?

    Thanks for you! I'll have a try.
  20. smilife

    how to read field of Binary[n] in SQL Server Table by TQuery?

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

Part and Inventory Search

Back
Top