Re: Looking for ORACLE/Sql Forms 3.0 help

thanks for all of the keen answers. I turned out to have two problems.

The first was the SQL problem as describe - this was fixed by doing:

SELECT field4

	into :input.field4
	from mytable

	where (mytable.field1 = :input.field1 and
		mytable.field2 = :input.field2 and


		((:input.field3 is NULL and mytable.field3 is NULL) OR


		(mytable.field3 = :input.field3))


	      )

	ORDER by field4

Thanks to a co-worker for figuring this one out. The other problem, which came up next, was 'triggered' by a couple of net readers comments.

I am work on my first pass thru the form and had not yet set up the triggers that I was going to need. So when I went to test this new solution, I typed in some non-existent data into field3 and went on to the next field. Of course, there was no edit to warn me about this, and thus I was getting some unexpected results from the next select.

Thanks everyone!

-- 
Larry W. Virden			UUCP: osu-cis!chemabs!lwv27
Same Mbox: BITNET: lwv27_at_cas    INET: lwv27_at_cas.org
Personal: 674 Falls Place,   Reynoldsburg,OH 43068-1614
America Online: lvirden