Version: 1.1.3 (KOffice 1.6.3) (using KDE 3.5.7, Gentoo) Compiler: Target: x86_64-pc-linux-gnu OS: Linux (x86_64) release 2.6.21-gentoo-r2 I create a script that opens a connection with tables, queries I make a runtime error... So the connections are still open... Kexi refuses to save any change...
probably just catch the error with something like; try: doStuffThatCouldRaiseAnException except: closeConnection ?
I don't care if my script crashes... But it is not a normal behaviour that then, I cannot save my document...
manolis, could you attach _small_ example database with script having such problem so we can return to the topic during the development?
Created attachment 21656 [details] example sqlite3 database Take a look at script2 object . On purpose I have con2 (instead of con1) to produce a runtime error. The I get undefined error when running the script. After that , If I modify my code... I cannot save the document with the following error: Saving object's data failed. Details: Message from server: cannot commit transaction - sql statements in progress Sql statement: commit Server result:1
Resolving these types of bugs as LATER. In Kexi 3.x we're going to have final scripting support. In 2.x it's experimental.