Page 1 of 1

unidac and fetchall

Posted: Tue 22 Dec 2009 20:31
by lao
Fetchall is false by default for interbase and true for postgresql.
When we migrate from interbase to postgresql, all querys and tables in the the project are changed the fetchall to true.
It is better if the default properties are sames for all providers.

Posted: Wed 23 Dec 2009 13:04
by Plash
By default UniDAC uses optimal way for each provider. For InterBase optimal is FetchAll=False. For PostgreSQL this mode requires an active transaction or additional connection. So PostgreSQL uses FetchAll=True by default.