Value from Cache in Cascading prompt

Hi

There is strange problem.I am using cascading prompt.
When i click values for first prompt it shows some default values (which was selected for last time login for other user) for second prompt.

This is strange and wrong.

Please suggest

Thanks
KRG


krgodbole (BOB member since 2003-02-24)

It may be undesirable in your case, but not wrong. It’s by design. Default behavior is that the LOV (which is stored locally on the workstation) retains its contents between uses, saving the time and database resources required to refresh the LOV. You have two choices … train your users to refresh it themselves as needed, or change the properties in Designer so that the LOV is automatically refreshed each time it is used.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)