Página 1 de 1

Sqlite : Multi User Environment

Publicado: Sab Ago 31, 2013 1:21 pm
por Milan Mehta
I am trying Sqlite. It works fine with Single User environment. Kindly guide
me on :
1. What care I need to take when more than one user access the same database
?
2. I have read that : Each entry in an SQLite table has a unique 64-bit
signed integer key called the "rowid". How to access that field ?
TIA
Milan.

Sqlite : Multi User Environment

Publicado: Dom Sep 01, 2013 2:11 pm
por ignacio
Milan Mehta escribió el sáb, 31 agosto 2013 13:21I am trying Sqlite. It works fine with Single User environment. Kindly guide
me on :
1. What care I need to take when more than one user access the same database
?
2. I have read that : Each entry in an SQLite table has a unique 64-bit
signed integer key called the "rowid". How to access that field ?
TIA
Milan.
1) Always use transactions. That's all.
2) That field is used internally by Xailer. You can reach it with the following code:
oDataset:oRecords:RowId()
Regards,