Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keep a value in a list box on enter-query?
Message
 
 
To
23/03/2000 17:25:42
General information
Forum:
Oracle
Category:
Forms
Miscellaneous
Thread ID:
00349711
Message ID:
00350701
Views:
25
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform