Re: Looking for ORACLE/Sql Forms 3.0 help

In article <1992Jan15.172205.8471_at_cas.org> lwv27_at_cas.org (Larry W. Virden) writes:

   SELECT field4

	   into :input.field4
	   from mytable

	   where (mytable.field1     = :input.field1 and
		   mytable.field2    = :input.field2 and
		   mytable.field3(+) = :input.field3)

	   ORDER by field4

Have you tried using an outer join??? I think it should be available to forms 3.0 doing what you are trying to do. It returns the "TRUE" of an equi join when both sides of the '=' are null (this is to allow parents to have optional children). I think it should work, but I haven't tried it though. My only problem is which side should the outer join symbol go. I think the way I have updated your code above is correct (unfortunately I can never remember so I just have a go and see which produces the results I am expecting). If not put the '(+)' between the ':input.field3' and the ')'.

Good luck.

--
David Owen, Praxis plc, 20 Manvers Street, Bath BA1 1PX UK.
Tel:	+44-225-444700.   Email:   dowen_at_praxis.co.uk

 "You needn't be well to be wealthy,
  but you've got to be whole to be holy"
                              -- Greg Lake