sequential number generator

Results 1 to 2 of 2

Thread: sequential number generator

  1. #1
    Mark Guest

    Default sequential number generator

    I would like to add a sequential number to a form that my visitors will fill in on my website. In other words each time somebody access the form it must show a refernece number (the sequential number) and this number has to be added to the same database as the details of the form.

  2. #2
    Join Date
    Dec 1969

    Default RE: sequential number generator

    Add a field to the input form (sequence number), create a sequence, if using oracle then:<BR>create sequence sequence_name start with anyvalue;<BR>--------------------------------------------<BR>make a select statement in the input form which picks up the next number from the sequence as:<BR>select sequence_name.nextval from dual;<BR>----------------------------------------------<BR>hope this helps.

Posting Permissions

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