Sergey,

I have ran each line with AERROR(). Here is the return (REM: I do have a valid connection, lnConn = 1):

>*-- But, here is a problem.  lnTableCount Returns -1
lnTableCount = SQLTABLES(lnConn, 'TABLE', "_tablelist")

*-- AERROR RETURNS:
*-- [1] 1526
*-- [2] "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
*-- [3] "[Microsoft][ODBC Visual FoxPro Driver]Function sequence error"
*-- [4] S1010
*-- [5] 0
*-- [6] 1
*-- [7] .NULL.

lnData = SQLEXEC(lnConn, "SELECT * FROM TEST1", "_TESTDBF1")
*-- AERROR RETURNS:
*-- [1] 1526
*-- [2] "Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Invalid file descriptor."
*-- [3] "[Microsoft][ODBC Visual FoxPro Driver]Invalid file descriptor."
*-- [4] S1000
*-- [5] 111
*-- [6] 1
*-- [7] .NULL.

So, there is something wrong in there but I am missing it. I know that [6] is the correct handle ID. The reason I am trying this is to learn how to get data without PATH() type commands, or hardcoding any path at all.

Ric