Create_Group_From_Query

From: Courtney Wright <lili96ilil_at_netzero.com>
Date: Fri, 23 Jul 1999 10:48:07 -0400
Message-ID: <wg%l3.507$Bp2.48967_at_news.oh.voyager.net>

[Quoted] I'm using Forms 4.5. I'm using the Create_Group_From_Query command to make [Quoted] and populate a group at run-time. I was able to create the group with the sql:

[Quoted] 'SELECT RNumber, RNumber FROM Work_Order'

When I add a WHERE to the statement, Oracle doesn't want to create the group. I've tried:

'SELECT RNumber, RNumber FROM Work_Order WHERE WONumber1 = '186-98''
'SELECT RNumber, RNumber FROM Work_Order WHERE WONumber1 = '||'186-98'
'SELECT RNumber, RNumber FROM Work_Order WHERE WONumber1 = '||:(bind
variable)

[Quoted] Nothing seems to work. Any ideas?

Courtney Received on Fri Jul 23 1999 - 16:48:07 CEST