OraFAQ Forum: Forms » Insert a record in the first row

Home » Developer & Programmer » Forms » Insert a record in the first row

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Insert a record in the first row [message #215193]

Fri, 19 January 2007 10:54

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

Report message to a moderator

Re: Insert a record in the first row [message #215368 is a reply to message #215193]

Sun, 21 January 2007 21:52

djmartin
Messages: 10181
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.

David

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 10 03:39:14 CDT 2025