Forms 3, Enter Query mode, and field validation
From: Michael Nolan <nolan_at_notes.tssi.com>
Date: Thu, 20 Jan 1994 00:16:51 GMT
Message-ID: <CJwJG4.6o8_at_notes.tssi.com>
Date: Thu, 20 Jan 1994 00:16:51 GMT
Message-ID: <CJwJG4.6o8_at_notes.tssi.com>
Background: Using Oracle 7.0.12.1.1 on an NCR 3445 and Forms 3.0.16.12.3
When in Enter Query mode, Forms doesn't perform any validations. This permits you to enter otherwise invalid data, such as a date field of %-JAN-94.
The problem is, any attempt to _do_ anything with a date field containing such a value will invoke validation checks. (All I really want to do is to see if the date field is null or not in the PRE-QUERY trigger, although it would be nice if I could do other things with it as well.)
Does anybody know a way around this?
--- Michael Nolan, Tailored Software Services, Inc. Lincoln, Nebraska Sysop for the GEnie DBMS RoundTable nolan_at_notes.tssi.com, dbms_at_genie.geis.comReceived on Thu Jan 20 1994 - 01:16:51 CET