Re: Forms 3.0 Question
From: Kim Ng <kimmng_at_pebbles.uswnvg.com>
Date: 14 Feb 1995 18:39:25 GMT
Message-ID: <3hqtct$4r9_at_fred.uswnvg.com>
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!)
Kim Ng
Paradigm Computer Consulting, Inc.
20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012
U.S.A. Received on Tue Feb 14 1995 - 19:39:25 CET
Date: 14 Feb 1995 18:39:25 GMT
Message-ID: <3hqtct$4r9_at_fred.uswnvg.com>
If you want to build a dynamic "select" or a dynamic "default where/order by" in SQL*FORMS 3.0, the answer is ..... You can't! The reason is: there is no way to tell SQL*FORMS 3.0 to execute your dynamic SQL statement!
The only one approaching dynamic query is using the "PRE-QUERY" trigger for a database block. However, you will have to associate the block with a table when you create the block. You can't change it dynamically.
(Whatever I say and own are mine, mine and only mine! So, don't you dare claim they are yours!)
Kim Ng
Paradigm Computer Consulting, Inc.
20611 E Bothell-Everett Hwy SE, Suite 280 Bothell, WA 98012
U.S.A. Received on Tue Feb 14 1995 - 19:39:25 CET