Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot access the selected table
Message
De
27/01/2006 08:22:25
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Cannot access the selected table
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01090856
Message ID:
01090856
Vues:
63
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)
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform