Icon View Incident Report

Serious Serious
Reported By: Petter Topp
Reported On: 2/11/2016
For: Version 2.04 Build 1
# 4395 Transactions Against ADO DataSets Using MySQL ODBC Driver Experience Commit Error

I have the following query used with a dataset defined in the DataSet Manager. 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.

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



Comments Comments
The underlying problem was with the parameter handling in MySQL, specifically that MySQL does not support discoverable parameter types. This required a re-write of the ADO data access layer in EWB in order to work around this issue.


Resolution Resolution
Fixed Problem on 4/15/2016 in version 2.05 build 1


Products Affected Products Affected
Elevate Web Builder
Elevate Web Builder Trial

Image