<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>5 Mar 2021 10:38:00 Z</lastBuildDate><pubDate>5 Mar 2021 10:38:00 Z</pubDate><description>I have a simple Sqlite table defined in the analysis.&#13;
With RAD I have generated a window with a table displaying the contents of this data. This works correctly.&#13;
&#13;
The form allows entering the data for a new item. &#13;
The data is then written into Sqlite table with hSave.&#13;
&#13;
After adding first item successfully  the second hSave always fails with Sqlite error:&#13;
        can not start a transaction within a transaction&#13;
&#13;
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.&#13;
&#13;
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.&#13;
&#13;
I have not found a way make it work. The transaction is started implicitly and the database is locked.</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/68362-windev-sqlite-can-not-start-transaction-within-transaction/read.awp</link><title>Windev - SQLite - can not start a transaction within a transaction</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster></channel></rss>
