| sequence number [message #80280] |
Tue, 03 September 2002 04:22  |
bezgouri
Messages: 3
Registered: September 2002
|
Junior Member |
|
|
hi all,
i have a master detail bloc.
the detail block B contains 10 lines
and the table B contains a field line_id
i want to insert the line_id(it's generated from 1 to 10) in the table B
now in order to insert i just do ommit but how can i insert the line_id
thanks in advance
|
|
|
|
| Re: sequence number [message #80288 is a reply to message #80280] |
Tue, 03 September 2002 17:52  |
Tejpal Saraswat
Messages: 22
Registered: August 2002
|
Junior Member |
|
|
Hi bezgouri
Just write in the Pre-Insert trigger
:block_name.Line_ID := sequence_no
automatically ur sequence will get inserted in to Table.
try it.
best Regds
Tej
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
