Databases Reference
In-Depth Information
Syntax check
Improper use of syntax is a common cause of errors. Fortunately, QlikView has a
feature that will catch these errors as they happen:
Syntax Check
.
As we saw earlier, QlikView script has syntax highlighting. Whenever incorrect
syntax is detected, the statement is underlined in a red squiggly from that point
onward. In practice, this means that often the error was made in the line that appears
before the red underlined text. The following screenshot shows a piece of script with
a syntax error, see if you can see what the error is.
If you looked closely at the script in the previous picture, you will have noticed that
there was a comma missing after the
TableName
column. This causes the statement
to be underlined in red from that point onward.
Besides catching errors on-the-fly, we can also run a syntax check over the entire
document by selecting
Tools | Syntax Check
from the menu, or by clicking the icon
showing an arrow underlined in red, the right-most icon on the toolbar.
Saving logs to disk
When a reload is performed in QlikView, a log of all activity is shown in the
Script
Execution Progress
window. A copy of this log can also be saved to disk so you can
review it at a later time. If you haven't already set this up for the current example
document, please follow these steps to generate log files:
1.
Go to
Settings | Document Properties
to open the
Document Properties
.
2.
On the
General
tab, check the
Generate Logfile
checkbox.
