Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error: Cannot access selected table
Message
De
26/09/2002 00:23:51
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00704557
Message ID:
00704559
Vues:
20
>I keep getting the error "Cannot access selected table" in an application I'm working on. The problem occurs with a listbox that is bound to a cursor created inside the control's Requery method. Any ideas?

If you're trying to write over same cursor it's incaccessible. You should set your rowsource to query and call listbox.requery. Maybe you don't need a query rowsource but just an SQL one. ie:
with myListBox
 .RowSourceType = 3 && SQL
 .RowSOurce = "select myfield1, myfield2 from myTable "+;
              " where myCriteria "+;
              " order by myField2" +;
              " into cursor crsLookup"
 .Columncount = 1 && Assuming you don't even want to show 2nd
endwith
myListBox.requery() && Would reload
Cetin

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform