Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    54

    Unanswered: How apply a sequence in form

    Dear All

    I'm using ORACLE 9i with formsds. I used a form for data entry which have a field 'Voucher no'. I created a sequence named voc_no. Now how I apply the voc_.nextvalue in 'voucherno' field. Is it used in trigger or in properties?

    Please help early.

    Thanks.

    Wasim

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Open item's Property Palette. Under its "Data" node you'll find the "Initial Value" property. Enter
    Code:
    :sequence.voc_no.nextval
    in there.

  3. #3
    Join Date
    May 2005
    Posts
    54
    Thanks for the reply. Its working.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •