>>
>>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
  * ODBC Error
  AERROR(laError)
  ...
ENDIF