QueryRecCount with ODBC
Posted: Mon 27 May 2013 14:12
Hi,
When counting records using QueryRecCount, I got an assertion failed in CRAccess.pas, line 3527 with the message '23'.
My configuration :
FetchingAll := False;
Options.QueryRecCount:= True;
Used Database : Oracle RDB
ODBC Driver : Oracle RDB Driver 3.03.02.03
With a very basic SQL statement : select * from Table1
dbMonitor shows that the executed query is : SELECT count(*) FROM ( select * from Table1 ) t
Please note that there is no problem with the syntax of this generated query : The ExecSQL returns with success. I have also used another SQL Tool and I tested with success the generated query.
But I get the assertion failure when I try to read the RecordCount property.
Thank you
When counting records using QueryRecCount, I got an assertion failed in CRAccess.pas, line 3527 with the message '23'.
My configuration :
FetchingAll := False;
Options.QueryRecCount:= True;
Used Database : Oracle RDB
ODBC Driver : Oracle RDB Driver 3.03.02.03
With a very basic SQL statement : select * from Table1
dbMonitor shows that the executed query is : SELECT count(*) FROM ( select * from Table1 ) t
Please note that there is no problem with the syntax of this generated query : The ExecSQL returns with success. I have also used another SQL Tool and I tested with success the generated query.
But I get the assertion failure when I try to read the RecordCount property.
Thank you