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

Thread: Autonumbers in Developer 2000

  1. 11-26-2000, 01:09 PM #1
    burgerboy
    burgerboy is offline Junior Member
    Join Date
    Nov 2000
    Posts
    1
    I need to autoincrement my doctorID
    so the user does not have to type the doctorid in each time

    how is this done

    any help will be much apreciated
    Reply With Quote Reply With Quote
  2. 11-27-2000, 07:47 AM #2
    m1l
    m1l is offline Junior Member
    Join Date
    Oct 2000
    Posts
    90
    Gareth,

    You could create a Oracle sequence and then use this sequence in a database trigger to update that field when you insert a record.

    Mike
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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