Refreshing TOraQuery

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Wojtek

Refreshing TOraQuery

Post by Wojtek » Mon 27 Dec 2004 13:27

Hi,

I'm using TOraQuery as master for other data components (usually TOraTable). Every time I change the query, I use Execute() method to get data. It seems to work fine, data controls changes its content.

But is using Execute() the most effective way of refreshing data in this case?

Alex
Posts: 655
Joined: Mon 08 Nov 2004 08:39

Post by Alex » Mon 27 Dec 2004 15:48

If you change SQL statement, you must reopen DataSet by calling "Open" or
"Execute" method or setting "Active" property to True, the performance in
all cases are identical.

Post Reply