🚀 go-pugleaf

Viatcheslav,

Okay, sorry found the problem. I was using "AutoIncrement" for the field
name. Apparently it's a reserved word ;-)

Thanks for your help,

Kim

"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:40e3b857$1@newsgroups.borland.com...
> What it your DBMS? In MS SQL Server do:
> CREATE TABLE Test (Col1 INT IDENTITY(1, 1) PRIMARY KEY)
>
> The same syntax works for MS Jet (MS Access), as well as:
> CREATE TABLE Test (Col1 COUNTER(1, 1) PRIMARY KEY)
>
> //------------------------------------------
> Regards,
> Vassiliev V. V.
> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
> ADO.Net
> http://www.oledbdirect.com - The fastest way to access MS SQL Server,
> MS Jet (Access) and Interbase (through OLEDB)
>
> "Kim Utley" <kim@simsware.com> �������/�������� � �������� ���������:
> news:40e31878$1@newsgroups.borland.com...
> > I have the need to use an autoincrement field in a database so the
primary
> > key will be unique. However I don't know the SQL syntax for it. I've
tried
> > "AUTO_INCREMENT", "AUTOINC" and "AUTO_INC" when creating the table
fields
> > but get a failure "Syntax error in field definition". Does anyone have a
> > brief example of doing this or the syntax?
> >
> > Kindest Regards,
> >
> >
> > Kim Utley
> >
> >
>
>