I am working on ORACLE version 6.0 and SQLForms30. I have the following problem.
I am desparately looking for some for help.
When I am in a perticular field of a block, I want to read the value entered
in the previous FIELD to list the values for the present field. I am not
able to write this one in the field definition block.
Example:
I have a field for PROJECTID and EMPLOYEEID
I want to read the value entered into the field PROJECTID before
listing the values of the employees. Because I want to list the
employees who are working in that project only.
I used following code in the field definition block
Let the name of the block be REQ_OREDER
select empid
into :REQ_ORDER.empid
from works_for
where REQ_ORDER.projid = works_for.projid
order by empid
