pqconnection1: Parameters of the type 'AutoInc' are not (yet)
supported.
lazarus / 16-Databases

----------------------------------------------------------------------
tatamata · 2016-02-29 12:53

Whn I migrated a project from SQLite3Connection to PQConnection, I get
error when opening datasets:
"pqconnection1: Parameters of the type 'AutoInc' are not (yet)
supported."
What does it actually mean and what should I do?
The SQLQueries involved are master/detail datasets using parameters
only to establish master/detail relation, no other parameters are
used....

----------------------------------------------------------------------
balazsszekely · 2016-02-29 13:00

AutoInc means when you insert a new record the ID is incremented to a
new available value.

----------------------------------------------------------------------
tatamata · 2016-02-29 13:06

Quote from: GetMem on February 29, 2016, 02:00:53 pmAutoInc means when
you insert a new record the ID is incremented to a new available
value.
I know that...
Something is different in behavior between postgreSQL (PQConenction)
and SQLite (SQLIte3Connection) regarding autoinc fields or
master/detail stuff, but I cannot figure out what.
Underlying tables in PostgreSQL and SQLite are identical, so the
applcaition should behave the same in both cases (coditional IFDEF
changes between them)...

----------------------------------------------------------------------
tatamata · 2016-02-29 13:40

Ok, I found it...it was in SQLQuery Params property that the
parameters type has to be changed from ftAutoInc to ftInteger. Now it
seems obvious.