REQUIRE.SELECT (or its synonym SELECT.ONLY) is the keyword you are looking for.
> QUERY = \SELECT PO.GROUP = 'Group Reference'\ > DATA \QSELECT PO.GROUP (2)\ > DATA \SSELECT POF BY GROUP BY-DSND PO.DATE\ > EXECUTE QUERY > > Well, this works absolutely fine as long as the user enters > in a group reference# that exists. Any variation on this theme should work: QUERY = \SELECT PO.GROUP = "Group Reference"\ DATA \QSELECT PO.GROUP REQUIRE.SELECT (2)\ DATA \SSELECT POF REQUIRE.SELECT BY GROUP BY-DSND PO.DATE\ EXECUTE QUERY or QUERY = \SELECT PO.GROUP = "Group Reference"\ QUERY<-1> = \QSELECT PO.GROUP REQUIRE.SELECT (2)\ QUERY<-1> = \SSELECT POF REQUIRE.SELECT BY GROUP BY-DSND PO.DATE\ I prefer 2 steps: QUERY = \QSELECT PO.GROUP "Group Reference" (2)\ QUERY<-1> = \SSELECT POF REQUIRE.SELECT BY GROUP BY-DSND PO.DATE\ EXECUTE QUERY (By the way, If you're building your own lookup don't forget about the SHOW verb.) cds ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
