Hi. I want to dynamically populate a data block from a dynamically built select statement. The select statement uses a join between two tables. The first table is always MyTable, but the second one is only known at run time. The data block is a detail block, so I have to pass some values to the select statement to be compared to MyTable's columns in the where clause.
I would rather build the dynamic statment in a procedure in the database than in Forms, but any solution would be appreciated.
I am using Forms 9.2 and Oracle 9.2
Thanks in advance.
Start Free Trial
