>Hello Fox/SQL experts :)!
>
>Yesterday i got help in writing this handle
>
>
>IF SQLExec(m.Handle, "SELECT * FROM useraccess", "test") " more than " 0
>but the thing is, i dont see the cursor "test" in the Data enviroment, i cant selcet it nor can i browse, the reason why im also wondering if this even executing is because if i do "Select *from peterpan" (peterpan being a table that doesnt exist) it doesnt error out on that line
>
>
>
>
>
>ive played around with it and changed it to
>
>SQLPREPARE(m.Handle, 'SELECT * FROM useraccess', 'test')
>SQLEXEC(m.Handle)
>
>but that doesnt seem to solve the problem

Ken,
there is a SQL Server tool named SQL Profiler.
You can tun it and see what query you sent to SQLServer.
Than you can copy and paste this query in SSMS and see the result.

BTW you ALWAYS should check the result or any of SQL* functions:

lnResult =  SQLEXEC(........)
DO CASE
   CASE lnResult < 0
        AERROR(laError)
        MessageBox(laError[1,2])
        RETURN
   CASE lnResult = 0
        ** Query still executes.
        ** You must wait here untill some resukt
OTHERWISE
        *** Success
ENDCASE