-
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.
-
1, set the item's 'default value' property to:
:SEQUENCE.my_seq.NEXTVAL
2, the block's 'query data source type' is table
list the tables in the 'query data source name'
and write the where clause in the 'where clause'
3, See the item's calculation properties
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
|