![]() | Products |
| Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.31 » View Incident Report |
| Reported By: Terry Swiers Reported On: 1/3/2020 For: Version 2.31 Build 10 |
procedure SQLCacheTest;
var
Number : Integer;
Q1, Q2 : TEDBQuery;
RecCount1, RecCount2 : Integer;
begin
Number := 1;
Q1 := GetQueryObjectSQL('select * from atable where number = :Number');
Q1.RequestSensitive := True;
Q1.ParamByName('Number').AsInteger := Number;
Q1.Open;
RecCount1 := Q1.RecordCount;
Q1.Free;
assert(RecCount1 > 0, 'No records to test with, please select a different number');
Q2 := GetQueryObjectSQL('select * from atable where number = :Number');
Q2.RequestSensitive := False;
Q2.ParamByName('Number').AsInteger := Number;
Q2.Open;
RecCount2 := Q2.RecordCount;
Q2.Free;
assert(RecCount1 = RecCount2, 'Record Count Missmatch');
end;This web page was last updated on Wednesday, April 8, 2026 at 04:38 AM | Privacy Policy © 2026 Elevate Software, Inc. All Rights Reserved Questions or comments ? |

