Recent

« previous next »
Pages: 1 [2]

Author Topic: SQLite, master/detail, inserting new records, auto-increment primary key  (Read 15749 times)

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: SQLite, master/detail, inserting new records, auto-increment primary key
« Reply #15 on: February 06, 2016, 12:12:23 pm »
Hm, it would be nice, but unfortunately, I just don't see that kind of behavior...
My SQLite3Connection has scoApplyUpdatesChecksRowsAffected=True, SQLTransaction.Action=caCommitRetaining, all SQLQuery components have: sqoAutoApplyUpdates=True, sqoAutoCommit=True, sqoKeepOpenOnCommit=True, sqoRefreshUsingSelect=True, UpdateMode=upWhereKeyOnly, UsePrimaryKeyAsKey=True.
Logged

LacaK

  • Hero Member
  • *****
  • Posts: 691
Re: SQLite, master/detail, inserting new records, auto-increment primary key
« Reply #16 on: February 06, 2016, 04:41:31 pm »
May be that your auto-inc column is not recognized as ftAutoInc field type.
In this case no auto refresh is applied.
Logged
Pages: 1 [2]
« previous next »
 

TinyPortal © 2005-2018