Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Uncaught Error: Database commit response error (Error)
Thu, Feb 11 2016 1:56 AMPermanent Link

Petter Topp

Hi.

Using EWB 2.04 Build 1 and MySQL Database.

I have a query:

select *
from topografi_hgr_version
where ai={ai=''}

The param is set and record is loaded and State is changed to dsUpdate.
Correct data is shown in various edit fields of my edit form.

Try to post data using code below but get Errormessage: Uncaught Error: Database commit response error (Error)

if DataSetSave.State = dsUpdate then
 if DataBase.InTransaction then begin
   DataSetSave.Save;
   DataBase.Commit;
 end;
Close;

Previously in my project, when I have edited a record, I have loaded all records of a table and the user have selected the record to edit in a grid.

In this case the table that contains data can be large (lots of records), so I don't want to load more than the actual record to edit.

What am I missing?

Br
Petter Topp
Thu, Feb 11 2016 7:29 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Petter,

Please email me the database (.zip please) and I'll take a look to see what the issue is.

Tim Young
Elevate Software
www.elevatesoft.com
Fri, Feb 19 2016 3:46 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Petter,

Okay, so very sorry about the long delay in getting back to you on this.

When I try to update the dataset with the same backend query, I see this error:

"Underlying database engine does not appear to support discoverable parameter types"

What this normally means is that the EWB web server (internal) is asking the MySQL ODBC driver about the data types of one or more of the parameters and not getting a legitimate answer.

I'm right in the middle of updating the dataset functionality of EWB for 2.05, so I'm going to have to get back to you on the actual details of what's going on in the code.

Tim Young
Elevate Software
www.elevatesoft.com
Image