Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
While trying to work out incremental load on a QVD, I ran into the following problem:
First I created a QVD file with all records. Then I do a database read and store the result in a resident table. To concatenate new records into my QVD, I do a where clause on the resident table, finding records which have been added since last QVD creation time.
So, I read the creation time into a variable, like this (and this works fine):
Let vAanmaaktijd = num(QvdCreateTime('$(vQVDfolder)TopDesk\QVD TopDesk Versionated.qvd'));
The contence of $(vAaanmaaktijd) = 42844,561724537
After the database load I try to do the following:
Nieuwe_records:
Concatenate (Stamtabel) LOAD * Resident TopDesk_Wijzigingen
where num([Datum aanmaak]) > $(vAanmaaktijd);
Drop table Nieuwe_records;
When reloading I get the following error message:
What am I doing wrong? the field Datum aanmaak (creation date) is in format DD-MM-YYYY hh:mm:ss
Try with single quotes
where num([Datum aanmaak]) > '$(vAanmaaktijd)'
May be use single quotes around your variable
Concatenate (Stamtabel)
LOAD *
Resident TopDesk_Wijzigingen
Where num([Datum aanmaak]) > '$(vAanmaaktijd)';
You were of course BOTH right!!
Thnx guys!! You really helped me out!!