Hi,

In DBISam I had the ability to see when a table was lastupdated. (TDBISamTable.lastUpdated property)

I was wondering how I can go about doing this in EDB please?

(I'm wanting to only refresh a query and dataset if changes have been made to the table).

Thanks & Regards

Adam.

Adam


I asked this is 2007 and the answer back then was no.

Is your query sensitive or can it be made so? If yes then no need to worry - a refresh will be very fast. If not then as long as you don't unprepare the query then if the underlying data hasn't changed it should be fast. Check it out in EDBManager. Create a query, run it then run it again without unpreparing.

Roy Lambert

Adam,

<< I'm wanting to only refresh a query and dataset if changes have been made to the table. >>

As Roy indicates, this isn't necessary in EDB, even with insensitive result sets.  During a refresh, EDB will check each table involved in the query and see if it has changed.  If none of the tables have changed, then nothing happens and the result is instantaneous.

So, there's no penalty for just calling Refresh.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Roy and Tim,

Thanks for the replies. I'll just call refresh regardless then and we should be right!

Best Regards

Adam.

Tim

>and the result is instantaneous.

I'm not sure about the instantaneous - I can see it blink in EDBManager <VBG>

Roy