Re: PL/SQL and FORMS30 questions

Although it does involve triggers, I prefer to use the on-database-record trigger to fill any and all fields with auto-generated data such as timestamps and sequence numbers.

The on-database-record fires whenever a record is first marked for update or insert( you can test for which within the trigger). Then inside that trigger you just assign the values to fields.

I do it this way because I don't want any default values assigned to fields until the user enters data into at least one of the enterable fields. If I use the default value thing, then those values are immediatly put into the fields, and the record is already marked for insert or update.

-- 


------------------------------------------------------------------

Steve Schow    | But you don't have to use the claw, if you
sjs_at_netcom.com | pick the pear with the big paw paw......
(415) 354-4908 | Have I given you a clue......?
               |                       - Baloo the Bear


------------------------------------------------------------------