unidac and fetchall

lao · Post by **lao** » Tue 22 Dec 2009 20:31

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.

Plash · Post by **Plash** » Wed 23 Dec 2009 13:04

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.