Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Having problems with table access
Message
From
02/07/1999 15:27:20
 
 
To
02/07/1999 11:55:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00236956
Message ID:
00237005
Views:
14
>I have a procedure that is triggered by clicking on various radio buttons. This procedure issues a SQL Select with the resulting data being placed in a table. note: (This table already exists as it was created by an earlier SQL Select). When I issue the refresh command for the list box that displays the information in the table, I get the error message "unable to access selected table". Does anyone know how to resolve this?

Set the listbox's rowsource to "" before requerying, and then set it back after you're done. Even though the structure of table might not have changed, you can't fool the listbox; it knows you messed with it's rowsource, and it's upset.
Erik Moore
Clientelligence
Previous
Reply
Map
View

Click here to load this message in the networking platform