Icon View Incident Report

Serious Serious
Reported By: Terry Swiers
Reported On: 10/23/2022
For: Version 2.36 Build 1
# 4906 Updating Published Tables Using Sensitive Query Result Sets Can Cause Access Violation

I have an example that loads a query into a FireDac memory table, touches the FD table, and then walks back through and applys the updates to the underlying EDB tables. An AV will appear when you post against the original EDB query.

I can prevent the AV by either unpublishing the CodeSale table, OR by using a separate EDB query or table to apply the updates.


Comments Comments
The issue was with sensitive queries that contain additional computed columns (added by the engine to satisfy query expressions) that also query tables that are published.


Resolution Resolution
Fixed Problem on 10/28/2022 in version 2.36 build 3


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB PHP Standard
ElevateDB PHP Standard with Source
ElevateDB PHP Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image