Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Keywords: statement handle and invalid cursor state
groups = qExecDirect(hstmtgrp,"SELECT * FROM %TableNameGroupDB% WHERE USERNAME = '%username%'")works without any problems. But a Statement like:
retcode = qExecDirect(hstmtusr,"UPDATE UserDB SET CreateUser=0")does not work. The same statement defined in Access97 works fine!
The ErrorMessage I get is:
24000 [Microsoft][ODBC Driver Manager] Invalid cursor stateI get this error every time no matter how i format the Statement.
Can anybody help me??
;SQL_CLOSE - FREES A SQL CONNECTION qFreeStmt(hstmt, 0) ;or ;SQL_UNBIND qFreeStmt(hstmt, 2)
Article ID: W12535
Filename: Invalid Cursor State Error.txt
File Created: 1999:04:15:16:47:54
Last Updated: 1999:04:15:16:47:54