Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!sdd.hp.com!samsung!uunet!munnari.oz.au!uhccux!larned
From: larned@uhccux.uhcc.Hawaii.Edu (Paul Larned)
Newsgroups: comp.databases
Subject: ORACLE forms problem
Keywords: forms 2.3, adding new record at top of descending order list
Message-ID: <11183@uhccux.uhcc.Hawaii.Edu>
Date: 29 Jan 91 19:50:44 GMT
Organization: University of Hawaii
Lines: 22

I am using version 5.1b for MSDOS, and forms 2.3 to develop an application.
In one screen I have a block showing four records from a table, one line
each, in descending order by a date field.  Thus, the most recent record is
the top line of the block.  I want to provide for input of new records, and
logically the next new record should provide a blank line ABOVE the most
recent record for data input.  However, when I press the [create record]
key, I get a blank line BELOW the first record.

I have tried using another block to simulate the table block, but cannot
write the appropriate commit statements to insert data into the table only
if the "new record" block is not null (in other words, I want to give the
end-user the option of NOT entering a new record, only updating an old
one).  In fact, if I try to write an "insert" statement in a KEY-COMMIT
trigger, I get an error "only select statements in non-commit triggers".
This makes little sense to me.

Naturally, I cannot find help in the manuals.  This seems like a logical
thing to want to do--are there any suggestions?

Thanks,
Paul Larned
larned@uhccux.uhcc.hawaii.edu