#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2004
    Posts
    1
    Rep Power
    0

    Question how to create column as AUTO_INCREMENT in Firebird SQL?


    new to Firebird.
    anybody can suggest me some website to get some resources for firebird?
    thanks a lot.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    250
    Rep Power
    14
    Hi,

    One website with tons of info - although a bit hard to find here and there - is www.ibphoenix.com

    As for auto-increment:
    Firebird doesn't have it. It does have "generators" though, that can generate unique numbers but aren't tied to a table or anything.

    For starters, download yourself the InterBase 6 documentation (the basis of Firebird) and the Firebird 1.5 release notes to get up-to-date.

    If you have any specific questions, feel free to ask.
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  4. #3
  5. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Cool


    You need to create an generator and then a trigger

    Read about triggers and generators in the manual

    http://ibphoenix.com/main.nfs?a=ibph...qlref#RSf77648

    http://ibphoenix.com/main.nfs?a=ibph...qlref#RSf77648
    Last edited by mariuz; March 20th, 2004 at 12:16 PM.
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo