Re: SQLForms30 HELP!!!

In article <1992Nov3.034640.20197_at_ra.msstate.edu>, pkm1_at_Ra.MsState.Edu (Praveen Mereddy) writes:
> 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
>
Maybe it works this way

	select empid
	into :REQ_ORDER.empid
	from works_for
	where works_for.projid = :REQ_ORDER.empid
	order by empid

-Mikko

>
> .....Here works_for is a table consisting a composite primary key
> of empid, projid
>
>
> help is appreciated
>
> Praveen
> pkm1_at_ra.msstate.edu

-- 
MIkko Kuismin