Page 1 of 1

Raise Exceptionwhen using QueryRecordCount=true

Posted: Fri 26 Feb 2010 16:23
by enzorubino
Hi,
In Delphi6 IDE with TUNIQuery connected to SQLite provider,

if i set QueryRecordCount option to true, when i try to use RecordCount property it raise this exception:

...EAssertionFailes with message '23 (D:\Projects\Delphi\Dac\Common\Source\CRAccess.pas, line 2822)'. Process Stopped.....

this is example code:

with UNIQuery1 do
begin
..
Options.QueryRecordCount=true;
..
if (RecordCount>0) <<< ERROR
then..
end;

thanks for help

Posted: Fri 26 Feb 2010 19:02
by tobias_cd
Maybe there's simply an "Open" missing before use of RecordCount (regardless of the option).

open is present

Posted: Tue 02 Mar 2010 10:39
by enzorubino
Command open is present before testing recordcount member, see code:

with UNIQuery1 do
begin
..
Options.QueryRecordCount=true;
Open;
if (RecordCount>0) <<< ERROR
then..
end;

Posted: Wed 03 Mar 2010 14:21
by Dimon
Thank you for information. We have reproduced this problem and fixed it. This fix will be included in the next UniDAC build.