topic About delete in QlikView

About delete

Thu, 09 Dec 2010 04:17:09 GMT

Hi All,

The following code is from help about deleting records. But why do we use "If ScriptErrorCount = 0 then " clause, what's the meaning of it?

Let ThisExecTime = Now( );

QV_Table:

SQL SELECT PrimaryKey, X, Y FROM DB_TABLE

WHERE ModificationTime >= #$(LastExecTime)#

AND ModificationTime < #$(ThisExecTime)#;

Concatenate LOAD PrimaryKey, X, Y FROM File.QVD

WHERE NOT EXISTS(PrimaryKey);

Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO File.QVD;

Let LastExecTime = ThisExecTime;

End If

About delete

Oleg_Troyansky — Thu, 09 Dec 2010 06:58:08 GMT

The meaning is that all the SQL and LOAD statements above were successfully executed with no errors. You don't want to override a "good" QVD file with potentially "Bad" data if something went wrong.

About delete

Thu, 09 Dec 2010 07:03:48 GMT

Hi,

Thanks for your reply, does it mean we should always use this clause before overriding the QVD?

Isaac Li

About delete

Oleg_Troyansky — Thu, 09 Dec 2010 07:05:53 GMT

I'm not sure if everyone is always using it, but it does look like a good practice, especially if SQL or ODBC errors are frequent.

About delete

Thu, 09 Dec 2010 07:11:03 GMT

Hi,

During the execution of script the number of statements caused error will be retured by this statement. You are able to find this when you will open your Qv log file.

Regards,

Ravi