Home » Developer & Programmer » Forms » FORMS (9I)
icon4.gif  FORMS [message #486347] Wed, 15 December 2010 01:32 Go to next message
hketh786
Messages: 6
Registered: December 2010
Location: India
Junior Member
I WANT TO KNOW HOW TO USE SEQUENCE IN FORMS9I BLOCK. SUPPOSE I HAVE A MANUALLY CREATED DATABLOCK AND A FIELD CALLED EMPLOYEE "SSN_NUMBER"
I WANT IT TO BE AUTO GENERATED EACH TIME ??

[Updated on: Wed, 15 December 2010 01:35]

Report message to a moderator

Re: FORMS [message #486352 is a reply to message #486347] Wed, 15 December 2010 01:41 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Do not post in all capitals - it is considered shouting.

You can use a when-validate-item trigger on the item or the pre-insert trigger on the block to do this.
Re: FORMS [message #486355 is a reply to message #486352] Wed, 15 December 2010 01:46 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Dear,

Please also read this post.

http://www.orafaq.com/forum/m/484199/81953/#msg_484199

Regards,
Irfan
Previous Topic: oracle forms 9i
Next Topic: FORMS
Goto Forum:
  


Current Time: Thu Sep 19 00:19:51 CDT 2024