Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trouble opening my SQL tables in my program
Message
From
29/07/2011 14:13:25
 
 
To
29/07/2011 13:42:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01519607
Message ID:
01519618
Views:
36
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform