ODBC provider and Query in Ingres database

[mariot]

I connect to database Ingres 10 with ODBC provider. Query "SELECT * FROM tablename" is returning only first record. Is it bug in UniDAC?
When I connected to other databases (e.g. Oracle), it return all records.
In Delphi Firedac ODBC those query return all record - but must be added connection parameter "ODBCAdvanced=SELECTLOOPS=N" (otherwise error).

Best regards,
Mario Tkacik

[AlexP]

Hello,

To solve the issue, you should set the FetchRows property of the Dataset to 1

[mariot]

Setting the parameter FetchRow to 1 helped, but only partially. When I run subqueries and when the FetchRow param is set to 1 and UniDirectional param is set to true, the subquery execution fails. I must set UniDirectional parameter to false - then all seems OK
Thanks for your help.

[AlexP]

You are welcome. Feel free to contact us if you have any further questions.