Home » Developer & Programmer » Forms » Serial number in Tablour style form (developer 6I Database xpress edition)
Serial number in Tablour style form [message #442637] Tue, 09 February 2010 11:22 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
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
Re: Serial number in Tablour style form [message #442691 is a reply to message #442637] Wed, 10 February 2010 00:16 Go to previous messageGo to next message
Littlefoot
Messages: 20824
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?.
Re: Serial number in Tablour style form [message #442791 is a reply to message #442637] Wed, 10 February 2010 09:35 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
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
Re: Serial number in Tablour style form [message #442806 is a reply to message #442791] Wed, 10 February 2010 13:17 Go to previous messageGo to next message
Littlefoot
Messages: 20824
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).
Re: Serial number in Tablour style form [message #446903 is a reply to message #442791] Wed, 10 March 2010 23:34 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Dynamic form size
Next Topic: Mximize window
Goto Forum:
  


Current Time: Sun Sep 25 04:15:56 CDT 2016

Total time taken to generate the page: 0.12613 seconds