Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using thisform in ComboBox.RowSource
Message
 
À
08/11/2013 13:59:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP3
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01587572
Message ID:
01587608
Vues:
71
>I want to use:
>SELECT * FROM MyTable WHERE MyField = thisform.MyObject.Text
>in ComboBox.RowSource property but I get error message that Thisform can be used only in methods.
>
>How to solve this?

Assuming that thisform.MyObject.Text is valid
(Try WAIT WINDOW TRANSFORM(thisform.MyObject.Text) and see what appears. If it's not text then that's your problem)
I have found that SQL does not like thisform so...
mText =  thisform.MyObject.Text
SELECT * FROM MyTable WHERE MyField = mText
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform