Icon View Incident Report

Serious Serious
Reported By: Michael Saunders
Reported On: 7/16/2021
For: Version 3.01 Build 2
# 4844 Clearing a Column During an Insert or Update Causes a Commit Error in a Server Application

I am having a problem inserting records from the server app. The following code works fine if initiated from the Client app however

The problem is with the TestDate column. It works Ok if I set a valid date value but when I try to null the value I get status code 500 returned.

    Database.StartTransaction;
    try
       TestTable.Insert;
       TestTable.Columns['TestField1'].AsString := 'PETE12';
       TestTable.Columns['TestField2'].clear;
       TestTable.Columns['TestInt'].AsInteger := 23;
       TestTable.Columns['TestDate'].clear;
       TestTable.save;
       Database.Commit;
       Request.SendContent('Record added');
    except
      if Database.InTransaction then
         Database.Rollback;
      raise;
    end;
end;

CREATE TABLE "TestTable"
(
"TestField1" VARCHAR(20) COLLATE "UNI",
"TestField2" VARCHAR(20) COLLATE "UNI",
"TestInt" INTEGER NOT NULL,
"TestDate" DATE
)
VERSION 1.00
READWRITE
UNENCRYPTED
INDEX PAGE SIZE 8192
BLOB BLOCK SIZE 1024
PUBLISH BLOCK SIZE 1024
PUBLISH COMPRESSION 0
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768
MAX PUBLISH BUFFER SIZE 32768



Resolution Resolution
Fixed Problem on 7/16/2021 in version 3.01 build 3


Products Affected Products Affected
Elevate Web Builder
Elevate Web Builder Trial

Image