Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Keep a value in a list box on enter-query?
Message
 
 
Information générale
Forum:
Oracle
Catégorie:
Formulaires
Divers
Thread ID:
00349711
Message ID:
00350701
Vues:
26
>We have a non database list box to provide a parameter for a form's where clause ( WHERE TO_CHAR(logdate,'YYYY') = :year_dd)
>in the WHEN-LIST-CHANGED trigger, we CLEAR_BLOCK(NO_VALIDATE)
>and ENTER_QUERY
>So far so good. ENTER_QUERY quite correctly clears the form. BUT we do not want the value in the list cleared. I have tried storeing the list value to a global and re-assigning to the list box in several places. Either nothing happens, or an error message occours.
>What is the Oracle equivilant to REFRESH? Or where should I restore the value to the list box?

You are still using a VFP form, right? What kind of source are you using for the combo box? Local table? Can the user enter a different value than what is offered in the list of values?

I would think that all you have to do is specify the .Value and .DisplayValue properties of the combo. As for preserving the previous value, I would put This.AddProperty('cValue') in the combo's INIT. In the InterActiveChange, I would have have This.cValue = This.DisplayValue. My assumption here is that .Value and .DisplayValue would be the same.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform