new to Firebird.
anybody can suggest me some website to get some resources for firebird?
thanks a lot.
-
No Profile PictureRegistered UserDevshed Newbie (0 - 499 posts)
- Join Date
- Mar 2004
- Posts
- 1
- Rep Power
- 0
how to create column as AUTO_INCREMENT in Firebird SQL?
-
No Profile Picture
- Join Date
- Dec 2003
- Posts
- 250
- Rep Power
- 18
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 -
Bug HunterDevshed Newbie (0 - 499 posts)
- Join Date
- May 2003
- Location
- Transylvania (Romania)
- Posts
- 309
- Rep Power
- 27
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#RSf77648Last edited by mariuz; March 20th, 2004 at 12:16 PM.
My home page: http://www.firebirdsql.org and work place :http://www.reea.net
March 17th, 2004, 08:59 PM
Reply With Quote
March 18th, 2004, 03:00 AM
March 20th, 2004, 12:00 PM
