General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL cursor select problem
I am trying to select a cursor from a MSDE database using the following code...
gnConnHandle = SQLCONNECT('KCHP') && returns 9
lnTest1 = SQLSETPROP(gnConnHandle, 'asynchronous', .F.) && returns 1 (ok)
lnTest2 = SQLEXEC(gnConnHandle, ;
'SELECT * FROM dbo.Policy WHERE cStatusId="C"', ;
'AA') && returns -1 (connection-level error)
No cursor is produced. I cannot fathom why the last line is failing. There are no error messages. Table dbo.Policy definitely exists in the database the connection is pointing to, as does the field cStatusId. Has anyone out there any idea what I might be missing?
TIA,
Alan Harris-Reid
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only