🚀 go-pugleaf

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
> >
> >
>
>