Re: Forms5 help

If you set the DEFAULT_WHERE property, then the where clause is changed "permanently". We are using a technique to set the search in Pre-QUERY which works well for us.

Say, the user enters the dates and presses the button. Then you place code in the Pre-Query trigger to catch this and prepare the SQL string and move it into the hiredate column (Query size property must be zero or N large enough for text).. something like this:

   vWrk := '#between '''||:first_Text_item||

           ''' and '''||:second_Text_item||'''';    COPY(vWrk, 'block.HireDate');

(The COPY command is used instead of an assignment statement...see the help on it).

This causes query to act as if user had pressed Enter-Query and typed a clause in the hiredate...
The Default_Where remains untouched, and after the query the next query does not know about the previous dates entered.

Good Luck,
Robert Proffitt
Beckman Coulter

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Dec 07 1999 - 18:25:32 CET