Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
LastUpdated Equivalent? |
Mon, Jul 10 2017 9:56 PM | Permanent Link |
Adam H. | 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. |
Tue, Jul 11 2017 2:22 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Jul 11 2017 1:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Jul 11 2017 6:57 PM | Permanent Link |
Adam H. | Hi Roy and Tim,
Thanks for the replies. I'll just call refresh regardless then and we should be right! Best Regards Adam. |
Wed, Jul 12 2017 3:25 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>and the result is instantaneous. I'm not sure about the instantaneous - I can see it blink in EDBManager <VBG> Roy |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |