Reported By: Roy Lambert Reported On: 3/24/2007 For: Version 1.01 Build 1
# 2284Single Boolean Column References in WHERE Clause Cause Access Violation The following SQL causes this error:
Access violation at address 005607B6 in module 'edbmgr.exe'. Read of address 00000008
SELECT * FROM Transactions
WHERE
NOT _Reconciled
AND
_fkAccounts = 5
CommentsThis problem could also manifest itself as irregular results for sensitive (not live or dynamic) query result sets.
ResolutionFixed Problem on 3/26/2007 in version 1.02 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial