Are you using QVD's to save your data.
If so would it by possible to save the last reloaded time and the number of records in the qvd
QvdNoOfRecords ('C:\MyDir\MyFile.qvd') so you can check if the qvd has been updated before you updated the last reloaded time.
Just a thought. I'm sure there is probably an easier way.
Thanks Mark for quick response.
Am storing the data into the QVD then that QVD's as usual using in application.
As per my understanding from your reply;
If my QVDnorecords is 500 as on yesterday
If the DB refreshment is delay so same 500 Records are there in QVD with old data.
Even if am using the QVDCREATETIME() in the UI level then its showing the TODAYs date in the UI level(i.e.Not required to the user) as because of application has ran before the DB refreshment.
Please correct me and guide the same.
Using the number of records in the qvd would work if the db refreshment always changed the number of rows.
If the application runs before the db refreshment the QvdCreateTime() would work if you where only doing incremental loads but I would this is not the case if you don't have a date field.