Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi to all,
I,m working with QV Perssonal Edition and tryng to create a QVD File "Insert Only", but WHERE & AND Statement does not working, see below the script.
OLEDB CONNECT TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=baan;Data Source=baan_10.72.102.100;Extended Properties=""] (XPassword is XXXXXXXXXXXXXXXXXXXXXXXX);
QVD_Table:
SQL SELECT* FROM BAAN.TTDSLS824804
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime<#$(BeginningThisExecTime)#;
Concatenate
LOAD* FROM Sales.qvd;
STORE QVD_Table into Sales.QVD;
How you can see the WHERE & AND are not in BLUE,
Any Idea abuot why this issue?
Thanks in Advence......
I think (though I am not certain about this) that any command after the SQL prefix is expected to be a valid SQL statement and Qlikview script editor does not validate the syntax of SQL statement, though it validates/checks syntax of Qlikview script.
Hi,
First, it seems to be an OR instead of an AND, since a single field cannot store more than one value.
Make sure both ModificationTime field and variables have the same date format and that this format is allowed into a raw SQL statement in your database's query analyzer.
Hope that helps.
BI Consultant