![]() | ![]() 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, October 30, 2024 at 11:41 AM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |