DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: forms

Hybrid View

  1. #1
    Join Date
    Mar 2001
    Posts
    78
    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.

  2. #2
    Join Date
    Jul 2001
    Location
    Hungary
    Posts
    4
    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
  •  


Click Here to Expand Forum to Full Width