Re: Forms 4.5 Querying Question

In article <01bc623a$cfdb1d00$1e01070a_at_Donna.ci.portsmouth.va.us>, Donna Morrow <morrowd_at_ci.portsmouth.va.us> wrote:
>I hope this question doesn't sound too dumb. I need to create a Form that
>allows the user to enter a value in the base table block when querying and
>then return all rows where the key value is >= the value entered by the
>user. I defined the block's WHERE clause to include base_table.column
>>= :block.item
 but the query only retrieves the row = :block.item instead of >=
>:block.item.
>
>I can do what I need by initiating ENTER_QUERY, entering a : in the base
>table item, EXECUTING QUERY and manually typing in the statement
>base_table.column >= 'value'; but I don't want the users to have to do
>this.
>
>Does anyone have any thoughts on this?? It would be particulary useful in
>a name search, for example, when I want to retrieve all rows >= 'JONES'.
>
>Thanks for any advice

As Mark Harris (in another response) said, you could set up a control block where the user types the name or value, then you could build your own where clause on the base-table block.

Also, you don't need to enter the colon and press Execute_Query, followed by typing the where-clause phrase. You can just enter
>=JONES during Enter Query mode. You don't even need the apostrophes.

Another method would be to grab and modify the where-clause in the on-select trigger. You could change the operator from = to >= there, and follow that process with a Select_Records command.

Good luck
Steve Cosner
http://members.aol.com/stevec5088 Received on Sun May 18 1997 - 00:00:00 CEST