Icon View Incident Report

Serious Serious
Reported By: Ralf Mimoun
Reported On: 11/1/2011
For: Version 4.27 Build 5
# 3509 Using Triggers with Live Result Sets That Access a Subset of Available Fields Can Cause AV

I added triggers to the db server. That means that TDBISAMEngine.TriggerCallback does what it should: look for the
trigger type and start the whole stuff.

In the client, I create a DBISAM query object with SQL = 'SELECT a, b FROM table WHERE ID=123'. a is a string, b is a BLOB field. That query is live.

Then I edit that query:

query.edit;
(query.fieldbyname('b') as TBlobField).LoadFromStream...
query.post;

That .post cause an exception in the server.


Comments Comments
The problem was caused by how BLOBs were being handled when there was a logical view applied to a physical table, such as is the case when a live query selects from only a subset of fields in a table.


Resolution Resolution
Fixed Problem on 11/2/2011 in version 4.31 build 2


Products Affected Products Affected
DBISAM CLX Client-Server
DBISAM CLX Client-Server with Source
DBISAM CLX Standard
DBISAM CLX Standard with Source
DBISAM VCL Client-Server
DBISAM VCL Client-Server with Source
DBISAM VCL Standard
DBISAM VCL Standard with Source
DBISAM VCL Trial

Image