Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
RowSource Type 3-SQL Statement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00852895
Message ID:
00852931
Vues:
9
Elgin,

You can run the SELECT into an array property of the cbo itself. Create a couple of custom properties on the cbo subclass and they can easily read their list of values as they Init():
select dispvalue, pk ;
   from metadata ;
   into array this.maList ;
   where datafield = this.cListType ;
   order by dispvalue
>I have a dropdown list combobox with the following SQL statement as the RowSourceType:
>
>SELECT * FROM metadata NOCONSOLE WHERE datafield = "cboRef"
>
>The Table "metadata" is placed in the Form's DataEnvironment. When I start the form, the results of this SQL statement appear in a browse window just before the form displays. How do I avoid this? I thought that's what the "NOCONSOLE" instruction is for. I know I can have the result set go to a cursor. But I prefer it not to, as I will have several other ComboBoxes using the same "metadata" table and similar SQL statements as their RowSourceType and I don't want all these temporary cursors being opened if I can avoid it.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform