OraFAQ Forum: Forms » increment the nombor

Home » Developer & Programmer » Forms » increment the nombor

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

increment the nombor [message #131221]

Thu, 04 August 2005 22:00

swchen
Messages: 15
Registered: July 2005
Location: malaysia

Junior Member

hello, Mr.David.. me swchen again here, me wanna know how i can set the data items field(data type-number) to auto increment??

Report message to a moderator

Re: increment the nombor [message #131236 is a reply to message #131221]

Thu, 04 August 2005 22:44

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

Senior Member
Account Moderator

Oracle doesn't do 'auto increment' as a Forms Builder property. Oracle uses 'sequence numbers', or you can maintain it manually.

Have a look at "Avoiding Gaps in Sequence Number Inputs" in this forum.

David

Report message to a moderator

Re: increment the nombor [message #131296 is a reply to message #131236]

Fri, 05 August 2005 03:42

saadatahmad
Messages: 452
Registered: March 2005
Location: Germany/Paderborn

Senior Member

hi,
you can use in
When-New-Record-Instance trigger:
:BLOCK_NAME.item_name := :SYSTEM.cursor_record;

Report message to a moderator

Previous Topic:	Alert Window Sizing in 3-tier environment
Next Topic:	How to search 'text' in form's PL-SQL(s)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 23:36:22 CDT 2024