Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have above code working as I wonted.
Every day new set of data is loaded and concatenated into master file (NBP.qvd) I had to use temp field called Date_check to achieve this.
at the begging I have tried different code which doesn't work for the incremental load
Could you be so kind and explain me why the bottom code is not working in that case?
Exists() is checking against the symbol table of field currency_date, and this table is updated with every new record read from NBP.qvd.
Since currency_date is not a primary key (guess you can have the same date for multiple currencies), you will only load new data for one currency.
hmmm,
without looking at your files, it is hard to guess, what might be wrong.
Technically script is OK.
Suggest to check the formatting for currency_date, and try to use NUM(TODAY()).
Peter
Exists() is checking against the symbol table of field currency_date, and this table is updated with every new record read from NBP.qvd.
Since currency_date is not a primary key (guess you can have the same date for multiple currencies), you will only load new data for one currency.
Now I got it, Thanks a lot !!!
So if I understood correctly the following scripts use primary_key and works perfectly