Re: restrictive query in Form builder

From: Sunder <Sunder.nochilur_at_pcm.bosch.com>
Date: Sun, 10 Oct 1999 18:43:04 -0400
Message-ID: <7tr4s1$h17$1@proxy2.fe.internet.bosch.de>

There are two ways of acheiving this,

1. You can set the DEFAULT_WHERE property of the s_product table to the where condition. Suppose you have a field called Product_type and you want to select all parts of TYPE SCREW then the value for the DEFAULT_WHERE property will be

     product_type = 'SCREW'

2. For the s_products create a pre-query trigger and set the where condition here.

    Suppose you have a field called Product_type and you want to select all parts of TYPE SCREW then

     in the pre-query trigger set

     :s_products.product_type := 'SCREW'

In both cases the where clause will always be set whenever query is executed.

Hope this helps,
Sunder
Snowie wrote in message ...
it may be very simple question, but i'm just beginner.

ok, when i open form I can fill it with 'execute_query'. Now I didn't want to pull out all records, I have criteria that will return actually 1 record.

what i have now in button response trigger

---

GO_BLOCK('s_product');
execute_query;

---

now I need to somehwo insert here WHERE clause.

please, help.

Genady Received on Sun Oct 10 1999 - 17:43:04 CDT