Hi Rick,

The VFP error 1526 means that there was ODBC error. The details of error are stored in the array populated by AERROR(). What's ODBC error message ( 3rd item of AERROR() array), for example?

>Hi all,
>
>I have a very curious problem here. I want to get data from many tables, so I created the follow lines:
>
>
>

>*-- The SQLCONNECT has already fired and I have a valid connection in lnSQLHandle
>
>lcSource = "select * FROM " + lcTable
>lcDestin = lcAlias
>lnTESTER=SQLEXEC(lnSQLHandle, lcSource, lcDestin)
>
>*lnTester is returning -1.  AERROR() is 1526.  But, when I run:
>
>lnTESTER=SQLEXEC(lnSQLHandle, 'select * FROM myTable', '_myTable')
>
>*-- all is well... comments please?
>
>

>
>
>Ric