Icon View Incident Report

Serious Serious
Reported By: BioSign GmbH
Reported On: 3/18/2013
For: Version 1.01 Build 5
# 3788 Single-Column Primary Keys in ADO DataSet Base Tables Can Cause Error During Commits

The following code causes the error:

"Database commit response error: Cannot find the row for updating"

    with MyQiu_Test1 do
      begin
      InitFind;
      Columns['NUMMER'].AsInteger:=1;
      if Find(False,True) then
         begin
         Update;
         Columns['Name'].AsString:='Hallo';
         DataBase.StartTransaction;
         Save;
         DataBase.commit;
         end;
      end;



Comments Comments
This was an issue with the way that the rows were being searched for single-column primary keys. The ADO layer didn't like that EWB was passing a variant array instead of just a single variant, and that was causing a conversion error that was trapped locally.


Resolution Resolution
Fixed Problem on 3/18/2013 in version 1.02 build 1


Products Affected Products Affected
Elevate Web Builder
Elevate Web Builder Trial

Image