Re: SQL*Forms PRE-QUERY trigger question...
From: I.Vinikovetsky <ilia_at_wescom.kharkov.ua>
Date: Sat, 27 Feb 1993 14:27:58 GMT
Message-ID: <1993Feb27.142758.19888_at_wescom.kharkov.ua>
Date: Sat, 27 Feb 1993 14:27:58 GMT
Message-ID: <1993Feb27.142758.19888_at_wescom.kharkov.ua>
Hi, Michael!
Let you try following scheme.
Define your non-database field as a "Query Allowed" one. When "enter_query"
command executed, Forms propose user to fill this field (and others, marked as
"Query Allowed"). After "exeqry" key pressed your PRE-QUERY trigger fires and
you can execute appropriate queries to select example information from DB into
database fields according to non-database fields contents.
Ilia Vinikovetsky, WESCOM inc., Kharkov, Ukraine Received on Sat Feb 27 1993 - 15:27:58 CET