OraFAQ Forum: Forms » Serial number in Tablour style form

Home » Developer & Programmer » Forms » Serial number in Tablour style form (developer 6I Database xpress edition)

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

Serial number in Tablour style form [message #442637]

Tue, 09 February 2010 11:22

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

I need Sequence generate in each row in tablour style form

Like

FA0015
FA0016
FA0017

(I dont want to use sequence because when i delete the row its conceder delete row in sequence )

Regards

Shahzaib

Report message to a moderator

Re: Serial number in Tablour style form [message #442691 is a reply to message #442637]

Wed, 10 February 2010 00:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you search the board for "sequence"? It has been discussed many times.

I didn't quite get the last sentence, as it opposes the first one (you don't want to use a sequence but you need to generate a sequence); what about deleting - what does it mean?.

Report message to a moderator

Re: Serial number in Tablour style form [message #442791 is a reply to message #442637]

Wed, 10 February 2010 09:35

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Due to not save the first row its give me same no in 2nd row in tablour

I need 1st row +1 in 2nd row without commit;

Select MAX(Column)+1 into :Block.Column from Table;

Why i am not using Sequence?

Due to when i update my record in form and commit the record its change my last save no and create a new sequence no

There for i don't need to use sequence

Regards

Shahzaib ismail

Report message to a moderator

Re: Serial number in Tablour style form [message #442806 is a reply to message #442791]

Wed, 10 February 2010 13:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

"MAX + 1" in an introduction into a disaster (in multiuser environment).

A sequence should be discussed in a matter of Oracle database object (which is created with the CREATE SEQUENCE command).

Depending on your requirements, you might also take a look at system variable (:system.trigger_record).

Report message to a moderator

Re: Serial number in Tablour style form [message #446903 is a reply to message #442791]

Wed, 10 March 2010 23:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry that I have been so long in replying. Have you solved your problem?

I suggest you use an Oracle Sequence, stored in a field that you do not display, as your primary key and then create this 'visible identifier' during the 'commit' process or via a database trigger.

David

Report message to a moderator

Previous Topic:	Dynamic form size
Next Topic:	Mximize window

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 12:40:30 CST 2025