U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » SqlArray/SqlCtrl/Select problem

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

SqlArray/SqlCtrl/Select problem [message #20223]

Sun, 01 March 2009 11:35

Didier
Messages: 680
Registered: November 2008
Location: France

Contributor

Hello,

I'm doing a competition results management soft for my favourite sport (spear fishing) and I encounter problems when trying to chain several panels in order to dynamically add/modify things.

the error is encountered is the following:

SQL Error : "cannot commit transaction - SQL statements in
progress"

Error statement: "COMMIT;"

I made an example project where the problem happens.
To reproduce the problem do the following:
Start soft
--> push [COMPETITER]
--> push [MODIFY CLUBS]
--> modify a club city name
--> Return
===> Error msg appears

I'm new to SQL programming, so my error is probably due to low level knowledge, but what I want to do is simple and I know it is possible so where is my error ??? Confused

Thanks

Attachment: SqlProblem.tar.gz
(Size: 2.25KB, Downloaded 241 times)

Report message to a moderator

Re: SqlArray/SqlCtrl/Select problem [message #20233 is a reply to message #20223]

Mon, 02 March 2009 16:28

mirek
Messages: 13975
Registered: November 2005

Ultimate Member

This is a bug in Sqlite3 U++ code. (sort of misunderstanding of sqlite3 API).

It is now fixed and fix will be uploaded to svn at the end of week; meanwhile I am posting two files to be replaced in Sqlite3 directory.

Attachment: sqlite3.zip
(Size: 4.15KB, Downloaded 216 times)

Report message to a moderator

Re: SqlArray/SqlCtrl/Select problem [message #20235 is a reply to message #20233]

Mon, 02 March 2009 19:45

Didier
Messages: 680
Registered: November 2008
Location: France

Contributor

Thanks for the quick reply !

I'll try it right now.
Mean while I found a work around for the problem: do a sql.Clear()
before calling the chained panel.
Was this valid or was I just lucky ?

Didier

Report message to a moderator