>>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
Before running this command, what is Handle variable's value.
If it's not broken, fix it until it is.
My Blog