----------------------------------------------------
SITUATION (using QV 12.02)
----------------------------------------------------
I'm loading a table and using a FOR loop to cyce through the rows.
AppInfo:
LOAD PadAppName,
QVWURL,
LoadExpression
FROM $(vQVDTransformPath)AppInfo.QVD (qvd);
The LoadExpression is a string column, and the value contains the some variation of the following:
MATCH(vServerID, 1, 2, 3) > 0
...where the "1,2,3" will include some variation of that combination of values (i.e. "1", or "1,2", OR "1,3").
My FOR loop is being used to set variables, and looks like this:
LET vServerID = 1;
LET vBtnAppAbortions = '';
LET vBtnAppAlliedHealth = '';
LET vBtnUNKNOWN = '';
LET NumRows=NOOFROWS('AppInfo');
FOR i=0 TO $(NumRows)
LET vURL = PEEK('QVWURL', $(i), 'AppInfo');
LET vLoopName = PEEK('PadAppName', $(i), 'AppInfo');
LET vLoadExp = PEEK('LoadExpression', $(i), 'AppInfo');
IF $(vLoadExp) AND LEN(vURL) > 0 THEN
IF vLoopName = 'Abortions' THEN
LET vBtnAppAbortions = vURL;
ELSEIF vLoopName = 'AlliedHealth' THEN
LET vBtnAppAlliedHealth = vURL;
ELSE
LET vBtnUNKNOWN = vURL;
END IF;
END IF;
NEXT;
----------------------------------------------------
MY PROBLEM:
----------------------------------------------------
When I reload the script, I get the following error message:
Script line error:
IF AND LEN(vURL)>0 THEN
As you can see, it doesn't appear to be evaluating the first condition. If I click the OK button, I get the following error message:
Script line error:
END IF
Even though I get those errors, the FOR loop *still* works as expected. When I run it through the debugger, the debugger shows the line being executed as follows (which looks correct to me) :
IF MATCH(vServerID, 1, 2, 3) > 0 AND LEN(vURL) > 0 THEN
-----------------------------------------------------
How can I get rid of these error messages?
