Page 1 of 1

QueryRecCount with ODBC

Posted: Mon 27 May 2013 14:12
by Guillaume
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

Re: QueryRecCount with ODBC

Posted: Tue 28 May 2013 08:49
by AlexP
Hello,

We haven't tested UniDAC with Oracle RDB. Such a problem doesn't occur with the ordinary Oracle ODBC driver. The problem may be due to the driver. Try using another ODBC RDB driver version.

P.S. Please specify the used UniDAC version.