topic Script Error in QlikView

Script Error

farolito20 — Thu, 13 Dec 2012 15:01:22 GMT

Help

That's my script and my error window

Let ThisExecTime = ReloadTime();

QV_Table:

LOAD BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid;

SQL SELECT BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid

FROM AdventureWorks2008.Person.Password

WHERE ModifiedDate >= #$(LastExecTime)#;

Concatenate LOAD BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid FROM File.qvd (qvd);

STORE QV_Table INTO QV_Table.qvd (qvd);

Let LastExecTime = ThisExecTime;

Re: Script Error

Thu, 13 Dec 2012 15:09:29 GMT

Have you tested the connection to the Database? And if so, try to find the table "AdventureWorks2008.Person.Password" through the select button under the Data tab.

Re: Script Error

farolito20 — Thu, 13 Dec 2012 15:13:18 GMT

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AdventureWorks2008;Data Source=COMGAD;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=COMGAD;Use Encryption for Data=False;Tag with column collation when possible=False];

Let ThisExecTime = Date(ReloadTime());

QV_Table:

LOAD BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid;

SQL SELECT BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid

FROM AdventureWorks2008.Person.Password

WHERE ModifiedDate >= #$(LastExecTime)#;

// AND ModifiedDate < #$(ThisExecTime)#;

Concatenate LOAD BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid FROM QV_Table.qvd (qvd);

//WHERE NOT EXISTS(PrimaryKey);

//Inner Join SQL SELECT PrimaryKey FROM DB_TABLE;

If ScriptErrorCount = 0 then

STORE QV_Table INTO QV_Table.qvd (qvd);

Let LastExecTime = ThisExecTime;

End If

Re: Script Error

Thu, 13 Dec 2012 15:35:27 GMT

Try to use the variable differently:

Let ThisExecTime = 'Where [ModifiedDate] >=' & Date(ReloadTime());

and then:

SQL SELECT BusinessEntityID,

ModifiedDate,

PasswordHash,

PasswordSalt,

rowguid

FROM AdventureWorks2008.Person.Password

$(ThisExecTime);

(You can of course use 2 different variables, one for the date(reloadtime) and the second for the string..)

Re: Script Error

Sun, 16 Dec 2012 12:13:42 GMT

You should also make sure that the Date(ReloadTime()) returns the same kind of date as ModifiedDate.

(YYYY-MM-DD or MM/DD/YYYY ect.)

Re: Script Error

SunilChauhan — Sun, 16 Dec 2012 12:28:39 GMT

have u tried this

FROM AdventureWorks2008.Person.Password

WHERE ModifiedDate >='$(LastExecTime)';

hope this helps