OraFAQ Forum: Forms » Sequence Number in Detail Block

Home » Developer & Programmer » Forms » Sequence Number in Detail Block

Sun, 30 April 2006 22:52

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

Dear All,

I want to insert the sequence number in detail block. How to do it?

Samit

Mon, 01 May 2006 01:42

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

Senior Member
Account Moderator

As you said in http://www.orafaq.com/forum/m/169942/67467/#msg_169942 all you need to do is, in the When-Create-Record trigger, populate the key field. I normally do this via a 'select' statement.

select seq.nextval
  into :blk.itm
  from dual;

David

Previous Topic:	couple of quick questions
Next Topic:	How to enable SQL TRACE for a particular Session through Forms6i?

Goto Forum:

]

Current Time: Tue May 05 20:18:11 CDT 2026