Re: Forms ?: :SYSTEM.n_STATUS

From: Gregory Smith <bigfoot_at_sequent.com>
Date: Fri, 15 Oct 93 22:01:55 GMT
Message-ID: <1993Oct15.220155.6440_at_sequent.com>


rchance_at_netcom.com (Ray Chance) writes:

>In Forms 3.0, how do the three :SYSTEM.n_STATUS fields change after a commit?
>Ex: When you create a new record, :SYSTEM.RECORD_STATUS = 'NEW'; what is it
>set to after commit? 'CHANGED'???

A 'NEW' record is a record that has had no values entered into database fields (except for forms default & enforce foreign key values, which don't count as "entered" values; values you put in with triggers, however, DO count, and will change a 'NEW' to an 'INSERT' record).

A 'NEW' record should change to an 'INSERT' record when a value is entered in a database field, because Forms will try to INSERT the record at the next commit.

An 'INSERT' record is changed to a 'QUERY' record after a successful commit, because the record is now consistent with the database, just as a queried record would be.

A record that is queried from the database also has a 'QUERY' status.

A 'QUERY' record becomes a 'CHANGED' record if any base table fields are updated.

A 'CHANGED' record again becomes a 'QUERY' record after a commit, because it is again consistent with the database.

NEW = new record with no user or trigger-entered values in base table

         fields.

INSERT = record that is ready to be posted as an insert.

CHANGED = record that is waiting to be posted as an update.

QUERY = record that is consistent with the database, and will not be

        affected by the next commit.

-G. Received on Fri Oct 15 1993 - 23:01:55 CET

Original text of this message