Bug 149990

Summary: Kexi does not save changes to script after running it
Product: [Applications] KEXI Reporter: manolis <manolis>
Component: ScriptingAssignee: Kexi Bugs <kexi-bugs>
Status: CLOSED LATER    
Severity: normal CC: mail, staniek
Priority: NOR    
Version: 1.1.3 (KOffice 1.6.3)   
Target Milestone: ---   
Platform: Gentoo Packages   
OS: Linux   
Latest Commit: Version Fixed In:
Sentry Crash Report:
Attachments: example sqlite3 database

Description manolis 2007-09-18 22:24:53 UTC
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...
Comment 1 Sebastian Sauer 2007-09-18 22:46:34 UTC
probably just catch the error with something like;
try:
  doStuffThatCouldRaiseAnException
except:
  closeConnection

?
Comment 2 manolis 2007-09-19 06:31:42 UTC
I don't care if my script crashes... But it is not a normal behaviour that then, I cannot save my document...
Comment 3 Jarosław Staniek 2007-09-19 09:24:51 UTC
manolis, could you attach _small_ example database with script having such problem so we can return to the topic during the development? 
Comment 4 manolis 2007-09-19 10:30:16 UTC
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
Comment 5 Jarosław Staniek 2015-10-31 21:07:54 UTC
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.