Message
 
 
To
23/03/2000 17:25:42
General information
Forum:
Oracle
Category:
Forms
Miscellaneous
Thread ID:
00349711
Message ID:
00350701
Views:
29
>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