Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Which methods to populate and keep fresh a list box
Message
De
18/01/2000 21:31:09
Charlie Schreiner
Myers and Stauffer Consulting
Topeka, Kansas, États-Unis
 
 
À
18/01/2000 20:12:43
Gail Heineman
Alaska Dept of Fish and Game
Anchorage, Alaska, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00318308
Message ID:
00319698
Vues:
13
>I've got it, finally, by putting
>
>IF USED('formversions')
> USE IN formversions
>ENDIF
>SELECT formver, formvername ;
> FROM fileconstants ;
> WHERE formchar = scanrun.formchar ;
> INTO CURSOR formversions
>
>into the Init event of the formverlist, which has a RowSource of formversions and Rowsourcetype of 6-fields, and the above code plus
>
>THISFORM.formverlist.INIT()
>THISFORM.formverlist.REQUERY()
>
>into the InteractiveChangeEvent of the combo box.
>
>No doubt you were all correct with your various suggestions - Once I started over with a blank form to get rid of accumulated accidental extra stuff that may have been buggering up my previous tries, I made rapid progress. My lesson - fewer events with less code is mo bettah. Thank you all.

No Doubt. :-) Actually, I haven't read everything carefully, but that doesn't stop me from making more suggestions.
THISFORM.FormVerList is really THIS
If you put the SELECT SQL statement in the Requery(), then you'll just have one statement in the InterActiveChange()
This.Requery()

Charlie
Charlie
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform