Re: [PHP3] ODBC and auto_increment

In article <NDBBKPKOKMEGEKJJFADMKEFMCDAA.papagel@ceid.upatras.gr>, papagel@ceid.upatras.gr ("Papagelis Athanasios") wrote: > Hi to all, > > Does anyone know if it is possible to use an auto_increment statement > when I create and Insert records to a Table using ODBC ? > I believe that it isn't possible to achive such a functionality directly, > but is there any other way ? You may be able to do something not unlike this: create sequence fooid; create table id( fooid int4 default nextval('fooid'), . . . ); create unique index fooidindex on foo(fooid); The problem with SQL is that there are so many standards to choose from. -- Richard Lynch | If this was worth $$$ to you, buy a CD US Customer Support Director | from one of the artists listed here: Zend Technologies USA | http://www.L-I-E.com/artists.htm http://www.zend.com | (this has nothing to do with Zend, duh!)