Create_Group_From_Query

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

'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)

Nothing seems to work. Any ideas?

Courtney Received on Fri Jul 23 1999 - 09:48:07 CDT