sqlite3dataset and PK on 2 columns

[GuidoCavalera]

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]

'if i use only one field yes ?'

without ? 

[BigChimp]

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]

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]

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)