SQLFreeStmt problem ?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

SQLFreeStmt problem ?

lollisoft
Hi,

I have the following problem when running my function under Linux:

The application hangs in a semop function call while the second SQLAllocStmt call.

Any ideas ?

Thanks, Lothar

retcode = SQLAllocStmt(hdbc, &hstmt);

// ...

retcode = SQLForeignKeys(hstmt, NULL, 0, NULL, 0,
        szTable, SQL_NTS, NULL, 0, NULL, 0, NULL, 0);

while ((retcode == SQL_SUCCESS) || (retcode == SQL_SUCCESS_WITH_INFO)) {
// ...
        retcode = SQLFetch(hstmt);
        if (retcode == SQL_SUCCESS || retcode == SQL_SUCCESS_WITH_INFO) {
           lbErrCodes err = ERR_NONE;

           if (isVerbose())
                printf("%-s ( %-s ) <-- %-s ( %-s )\n", szPkTable, szPkCol, szFkTable,
                szFkCol);
        }
}

SQLFreeStmt(hstmt, SQL_DROP);

retcode = SQLAllocStmt(hdbc, &hstmt); // <------------------- Hang -----------------------------


--
Lothar Behrens | Rapid Prototyping ...
Rosmarinstr 3 |
40235 Düsseldorf   | www.lollisoft.de




---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match