Subject | Dropping table from application |
---|---|
Author | kfoinfo |
Post date | 2002-10-24T09:13:05Z |
Hi there
in our application we create and drop a table which we need for
temporary use. Apparently, the drop doesn't work, since the table
keeps on growing, unless we disconnect from the database.
It does work in interactive mode from our frontends SQLExplorer,
WinSQL. We are using Gemini / Easysoft ODBC Drivers.
It does work as well on our DB2/2 Database (also through ODBC), but
not on FireBird 1.0.
The piece of code in question is:
<...>
HSTMT hStmt, hStmt1, hStmt2, hStmt3, hStmt4;
DBSystemCode code;
<...>
DBString DelString = "DROP TABLE HT_DSG_POSGEB";
code = SQLAllocStmt(Handle(), &hStmt);
<...>
code = SQLExecDirect (hStmt,(char*)DelString,SQL_NTS );
Commit();
DBString CreateString = "Create table HT_DSG_POSGEB (<col_desc>)";
code = SQLExecDirect (hStmt,(char*)CreateString,SQL_NTS );
Commit();
<...>
Compiler is Borland 5.0.2 using RogueWave db.hxx libraries. We are
running FireBird 1.0 as local server under Win2000, WinNT, usually
single user.
Thanks for any suggestion.
Klaus
in our application we create and drop a table which we need for
temporary use. Apparently, the drop doesn't work, since the table
keeps on growing, unless we disconnect from the database.
It does work in interactive mode from our frontends SQLExplorer,
WinSQL. We are using Gemini / Easysoft ODBC Drivers.
It does work as well on our DB2/2 Database (also through ODBC), but
not on FireBird 1.0.
The piece of code in question is:
<...>
HSTMT hStmt, hStmt1, hStmt2, hStmt3, hStmt4;
DBSystemCode code;
<...>
DBString DelString = "DROP TABLE HT_DSG_POSGEB";
code = SQLAllocStmt(Handle(), &hStmt);
<...>
code = SQLExecDirect (hStmt,(char*)DelString,SQL_NTS );
Commit();
DBString CreateString = "Create table HT_DSG_POSGEB (<col_desc>)";
code = SQLExecDirect (hStmt,(char*)CreateString,SQL_NTS );
Commit();
<...>
Compiler is Borland 5.0.2 using RogueWave db.hxx libraries. We are
running FireBird 1.0 as local server under Win2000, WinNT, usually
single user.
Thanks for any suggestion.
Klaus