topic Re: am using sql table in incremental load.am reload my script its following error is occured.can u please tell me where the problem? in QlikView

am using sql table in incremental load.am reload my script its following error is occured.can u please tell me where the problem?

Tue, 14 Apr 2015 11:28:44 GMT

am attached my script and error screen shot .please find the attachment.

Thanks & regards

raja

Tue, 14 Apr 2015 11:38:18 GMT

Hi raja,

looks like your variable isn't being handled as expected, try single quotes around it in your where clause
'$(vLastDateUpdate)'

Joe

MK_QSL — Tue, 14 Apr 2015 11:39:51 GMT

Use

Where LASTUPDATE > '$(vLastUpdateDate)';

Tue, 14 Apr 2015 11:41:31 GMT

Hi Joe,

when am loading the sql table.where clause not working on that table

Tue, 14 Apr 2015 11:42:35 GMT

same error occured

marcus_malinow — Tue, 14 Apr 2015 11:53:58 GMT

Try adding a TRACE command just before your Incremental_Load1 load to see if your variable is being set.

TRACE vLastUpdateDate = $(vLastUpdateDate);