You can use AERROR() function to see what error ODBC driver returns

=AERROR(laError)
? ALLTRIM( laError[1,3] )

>Hi!
>
>Im Querying a table using sqlconnect and sqlexec commands. Im trying to query a table with a parameter .T. The code is illustrated below. Please check if there is an error on my syntax

>nHandle = Sqlconnect("DNSname")
>cSQL    = [ Select * from DatabaseName!TableName WHERE fieldname = ] + [.T.]
>nResult = Sqlexec(nHandle, cSQL, "cur_tablename")

>with this code, nResult returns a negative value and does not produce the cursor I wanted to create base from the query.
>
>
>Any Help will be greatly appreciated
>
>thanks in advance...