Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot access the selected table
Message
From
27/01/2006 08:22:25
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Cannot access the selected table
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01090856
Message ID:
01090856
Views:
62
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
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Next
Reply
Map
View

Click here to load this message in the networking platform