|
| Inicio → WINDEV 2024 → Windev - SQLite - can not start a transaction within a transaction |
| Windev - SQLite - can not start a transaction within a transaction |
| Iniciado por vvido, 05,mar. 2021 10:38 - No hay respuesta |
| |
| | | |
|
| |
Miembro registrado
94 mensajes |
|
| Publicado el 05,marzo 2021 - 10:38 |
I have a simple Sqlite table defined in the analysis.
With RAD I have generated a window with a table displaying the contents of this data. This works correctly.
The form allows entering the data for a new item.
The data is then written into Sqlite table with hSave.
After adding first item successfully the second hSave always fails with Sqlite error:
can not start a transaction within a transaction
The program terminates and on next program run the table is displayed, BUT even the first item which seemed to be added is NOT in the table.
Obviously the first HSave results in adding (the table shows the added item), but not comitting the change. The second HSave tries to start a transation but it fails.
I have not found a way make it work. The transaction is started implicitly and the database is locked. |
| |
| |
| | | |
|
| | | | |
| | |
|