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
lgffff
Messages: 1
Registered: January 2007
Junior Member
Hi,

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.

George
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
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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.

David
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: Tue Dec 06 06:30:31 CST 2016

Total time taken to generate the page: 0.05293 seconds