sqlite3dataset and PK on 2 columns
lazarus / 16-Databases

----------------------------------------------------------------------
GuidoCavalera · 2013-09-25 08:35

hi,

sqlite3dataset work fine if i define 2 fields as PK ? or it want only
one field ?

I ve a table with PK on 2 column but applyupdates don't save records,
if i use only one field yes ?

It's correctly ?

BYE

----------------------------------------------------------------------
GuidoCavalera · 2013-09-25 08:37

'if i use only one field yes ?'

without ?

----------------------------------------------------------------------
BigChimp · 2013-09-25 08:39

Well, if SQLite supports multicolumn PKs then Lazarus/FPC should be
able to deal with it.

Please include a sample application or at least your table SQL,
Lazarus version, operating system. See the first link in my signature.

Preferably a sample application that demonstrates the problem
(project/publish project, zip up the result and attach it to a post).

Thanks.

----------------------------------------------------------------------
GuidoCavalera · 2013-09-25 14:12

i just upgrade to last lazarus 1.1 and fpc 2.7.1. Before this version
all go fine in fact in my application data applying on table with 2
PKs.

Early i post u a sample, my application is too complex.

Bye

----------------------------------------------------------------------
LacaK · 2013-09-26 07:22

If you are speaking about "sqlite3dataset" , so not sqlDB TSQLQuery +
TSQLite3Connection, then looking at sources it seems, that there is
supported only single column primary key.
(look at usage of FPrimaryKeyNo in unit CustomSqliteDS)