Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table
Message
 
 
To
27/01/2006 08:22:25
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01090856
Message ID:
01090858
Views:
7
Check Cannot access selected table error FAQ #18812

>On a form (vcx) I had a Combo "Combo1", with RowsourceType = 3, SQL statement and the actual statement
>
>Select Distinct Workshopname, Phone, City, WorkshopId from Workshops
>   Into Cursor crsWorkshops
>
>
>This worked just fine until I added another combo, "Combo2" , also with RowsourceType = 3 and the statement
>
>
>Select Recno() AS Incident, DamageId from Damages
>  Order BY 1 Desc Into Cursor crsIncidents
>
>
>Now Combo2 initializes fine, but Combo1 complains "Cannot access..."
>
>Workshops and Damages are both remote views.
>
>What to do?
>
>TIA & BR
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform