>You can't use the USE command with tables on a server. You have to send commands to the server to bring the data into local cursors. For example, if you want to bring the entire UserAccess table into a local cursor (which isn't really a good idea unless the table is quite small), you'd do something like:
>
>
>IF SQLExec(m.Handle, "SELECT * FROM UserAccess", "UserAccess")
> * Success
>ELSE
> * The query failed. You'll need to act appropriately.
>ENDIF
>
>* If you were successful, at this point, you have a cursor named UserAccess that you can
>* work with. Be careful not to close it, until you're really done with it.
>
>
>Tamar
ok thanks for the tip: but if am right (m.Handle, "SELECT * FROM UserAccess", "UserAccess") basically takes the connection handle from memory , the command and cursor name so.... im not so sure as to why im getting a data mismatch error