🚀 go-pugleaf

1, 1 - initial value and increment. If I am not wrong, AutoIncrement could
be used too. Try to enclose column names into brackets - there could be
keyword there:

CREATE TABLE Test ([AutoIncrement] COUNTER(1, 1) ...)

//------------------------------------------
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:40e42ca9@newsgroups.borland.com...
> Sorry it is MS Jet.
>
> When I create a table the statement is:
>
> CREATE TABLE Test( AutoIncrement COUNTER( 1, 1 ) [, other field names and
> types]
>     CONSTRAINT PrimaryKeyIndex PRIMARY KEY( AutoIncrement [, other field
> names and types]  )
>
> This works for all other tables that don't have the autoincrement
> type.However, when I add/use the autoincrement field I get the exception
> "Syntax error in field definition". Any idea what's causing this and what
> does the ( 1, 1 ) in the COUNTER mean?
>
> Kindest Regards,
>
> 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
> > >
> > >
> >
> >
>
>