>>
>>What is the code returned by SQLExec? -1 would indicate ODBC error. You can use AERROR() to get details about ODBC error.
>
>I'll check that out once I've put some records back in the file. Looks useful. How would I use AERROR in this context?
You should always check value returned by all SQL*() functions because it's the only way to know if it has been executed successfully or not.
lnresult=SQLEXEC(hconn,lcsql,"testdata")
IF lnresult = -1
AERROR(laError)
...
ENDIF
--sb--