Question About Incremental Build

Wed, 22 May 2013 06:22:44 GMT

Dear All,

I had copied a little piece of scrpt from a user in this community,

and I ' ve made some changes on it

my purpose:

1. load old data from QVD

2. find the last load time

3. incrementally load data from DB via ODBC

my script:

Temp:

Load * from (qvd);

Res:

Load MAX(XF_LASTMODTIME) as maxDate resident Temp;

et vMax = chr(39)&DATE(peek('maxDate',-1,Temp),'YYYY-MM-DD HH.MM.SS')&chr(39);

ODBC CONNECT TO [TNT11G;DBQ=TNT11G] (XUserId is GbHDbJRKRBSWUAJM, XPassword is YQQZSJRKRBSWUAJW);

New:

select * from xf_itemdm where xf_lastmodtime > TO_DATE($(vMax),'YYYY-MM-DD HH24.MI.SS');

for step 1, 2, the debugger tell me that the corresponding tabes' (temp, res) loading time and its number of rows returned

how ever, for step 3, it told me the load time of "Temp" instead of "New"- my expection.

was it really reloading data from database? or it was misled to load from the "Temp" table?

Thx a lot!

topic Question About Incremental Build in QlikView