Incremental Loading problem (Insert, Update Delete)

[#1]

Hello

This is my first post on the community although I have learn almost everything I know for Qlikview from it the last 3 years.

So thank you qlikview and qlikview fans for this massive knowledge offered so widely.

I have a problem with incremental loading script getting an error message as seen below.

Also I am attaching the script file I am using.

(the DB is SQLSERVER 2008)

The COSTMAIN_COSTDATE is (datetime , null) field and the select gives 2016-05-04 00:00:00.000.

Thanks in advance for any help provided

Michael M.

[#2]

Mr Wuhl

I don't know why but seems to work and update the qvd after the concatenation even though the 'Exit Script' command is placed before the Replace.

Thanks for your time you spend helping me.

I ll let you know when I will give the qvw to users.

COSTMAIN_EndINVENTORYCOST_AcnTotalCost,

COSTMAIN_ENDCOGS_DayHarvMedCost*/

FROM COSTMAINQVD.QVD (QVD) WHERE NOT EXISTS(CostmainID);

INNER JOIN

select CostmainID FROM z_costmain;

Exit Script;

//REPLACE OLD QVD FILE

Store Incemental into ; //COSTMAINQVD.QVD(qvd);

//Drop Incremental table

Drop Table Incemental;