OraFAQ Forum: Forms » forms record sequence

Home » Developer & Programmer » Forms » forms record sequence

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

forms record sequence [message #160122]

Thu, 23 February 2006 06:40

kamar_19
Messages: 52
Registered: June 2005
Location: pakistan

Member

aoa,
i m working in forms 6i and i want to show the records in the same sequence as i saved them or update or insert new record in between the records

regards
qamar

Report message to a moderator

Re: forms record sequence [message #160127 is a reply to message #160122]

Thu, 23 February 2006 07:14

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Well, unless you provide an ORDER BY, Oracle cannot and will not guarantee any order. You need to work out your ordering algorithm.

There is no implicit ordering whatsoever.

MHE

Report message to a moderator

Re: forms record sequence [message #160250 is a reply to message #160127]

Fri, 24 February 2006 01:49

samidc
Messages: 35
Registered: February 2006

Member

There is one option.

While user insert record or update record just insert or update the sequence number. i.e provide one hidden field and use it as a sequence. dont show it to user and while insertion updation just update the same and in a block property order the block with that sequence number

Thanks
SaMiR.

Report message to a moderator

Re: forms record sequence [message #160309 is a reply to message #160250]

Fri, 24 February 2006 06:13

Maaher
Messages: 7065
Registered: December 2001

Senior Member

And how do you implement it in a multi user environment? Lock the entire table when someone inserts a record in the first row of your Form? And be careful that you don't hit a mutating table error.
Anyway, I wouldn't recommend it.

MHE

Report message to a moderator

Previous Topic:	master-detail
Next Topic:	small help plz

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:53:08 CDT 2024