Home » Developer & Programmer » Forms » Insert a record in the first row
Insert a record in the first row [message #215193] Fri, 19 January 2007 10:54 Go to next message
Messages: 1
Registered: January 2007
Junior Member

How to add a new record as the 1st row? I tried to duplicate the original 1st row, insert a record between them and delete original 1st row. But it doesn't work because of foreign keys.
Your help is highly appreciated.

Re: Insert a record in the first row [message #215368 is a reply to message #215193] Sun, 21 January 2007 21:52 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
The code in the When-Create-Record trigger should use an Oracle sequence or a "max(value)+1" to specify the primary key.

Previous Topic: How to upload/attache text or other file in oracle table (attachment like Email)
Next Topic: returning list item datatype values to number datatype
Goto Forum:

Current Time: Thu Aug 17 14:22:55 CDT 2017

Total time taken to generate the page: 0.28338 seconds