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.
In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.
Sqlite : Multi User Environment
-
Milan Mehta
- Mensajes: 140
- Registrado: Dom Dic 27, 2009 9:54 am
-
ignacio
- Site Admin
- Mensajes: 9443
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
Sqlite : Multi User Environment
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,
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,
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com