-
Hi friends
I am a beginner in oracle forms and reports.
Please answer the following questions.
1)I am trying to generate eno automatically via seqence in emp table.While
giving a trigger
at block level pre_insert it is not working.Why?I had written the trigger as
select seqname.nextval into :emp.eno from dual;
But when I try the same trigger at new item instance(eno) it is working,but the
problem is
whenever I enter that eno item it is getting incremented and I am unable to
query the records.
2)Is it possible to select columns (items) from 2 tables in a single block.How?
3)Is it possible to update an item in the same block based on the value
entered to a different item.how?
Please help me.
thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|