> > > csSql += _T( "UserID INTEGER NOT NULL
> > > AUTO_INCREMENT," );
>
> csSql += _T( "UserID SERIAL NOT NULL," );
>
or,
csSql += _T( "UserID SERIAL PRIMARY KEY," );
Primary keys get the not null automatically. Serial, by the way, is
just shorthand for defaulting the primary key to a value pulled from a
sequence. It as a non standard extension just like AUTO_INCREMENT is,
but it is a *much* better abstraction of an incrementing key.
Merlin