Can be create a sequence on runtime form?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Can be create a sequence on runtime form?

  1. #1
    Join Date
    Feb 2001
    Posts
    30
    Hi all,

    I use form5 and I have group+runnint no. represent item no.
    Ex. aaaa0011. I create sequence name 'aaaa' and set item# : ='aaaa'||aaaa.nextval if new member. but the group can increase in runtime from if user need to define, then I should have sequence xxxx to control running no.

    How I create a sequence on run time form which sequence name is group name which user add up.

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    You can create objects in database during a Forms-program execution using the Forms_DDL package (check the Forms built-in help for more details and examples).

    []s
    Chiappa

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