Hi Alan,
You can use AERROR() function to get detailed descripton of ODBC error.
It's better to enclouse string literals in single quotes because it's standard string literal delimiter in SQL Server. The use of double quotes is controlled by SET QUOTED_IDENTIFIER command. If it set to ON double quotes cannot be used for string literals. See BOL for details. Try
lnTest2 = SQLEXEC(gnConnHandle, ;
[SELECT * FROM dbo.Policy WHERE cStatusId='C'], ;
'AA')
IF lnTest2 = -1
DIMENSION laError[1]
AERROR(laError)
...
ENDIF
>I am trying to select a cursor from a MSDE database using the following code...
>gnConnHandle = SQLCONNECT('KCHP')
>lnTest1 = SQLSETPROP(gnConnHandle, 'asynchronous', .F.)
>lnTest2 = SQLEXEC(gnConnHandle, ;
> 'SELECT * FROM dbo.Policy WHERE cStatusId="C"', ;
> 'AA')
>
>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?
--sb--