Page 1 of 1

QueryRecCount on ODBC

Posted: Thu 22 Mar 2012 01:09
by gangus
Hi,
I use ODBC to connect to SQL Anywhere. I have a TUniQuery component on a form with a simple query, 'select * from Customer'.
I have Fetchall in Specific options set to False and FetchRows at the default value of 25. The query opens fine.

If I then set QueryRecCount to true in Options, it gives me an SQL syntax error when I try to open the query..... If I then switch QueryRecCount back to false ( with no other changes ), it works fine again.

If Fetchall is TRUE I have no problems, but this value is slow on networks with large datasets being displayed in a TDBGrid.......

Also, is there any way of having FetchALL default to 'FALSE' when I drop a TUniQuery on a form.........

Cheers,
Gavin

Posted: Thu 22 Mar 2012 09:23
by AlexP
Hello,

Thank you for the information, we have reproduced and fixed the problem.
This fix will be included in the next build.