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