I have the following:


nConnHandle = SQLConnect("Sql_Data", "Kevin", "Kevin")

IF nConnHandle > 0

  nResult = SQLExec(nConnHandle, "select * from test", "Temp1")

  IF nResult > 0

    SELECT Temp1
    BROWSE NORMAL

  ELSE

    =AERROR(aErrInfo)
    ? aErrInfo[1,3]

  ENDIF

ENDIF


When I run this, nConnHandle is 3 but nResult is -1 and aErrInfo[1,3] contains:
[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'tblTest'


If I use a Connection in a DBC, all works fine, except that I'm forced to
use a DBC.

Can anyone tell me whats going on?

Thanks