if statement script error

[yelin_nyu]

I get an error msg from using script shown at bottom of this page --

Script line error:

IF 'tbl' <> ''

why?

SUB TraceRowCount (SourceTable)
IF '$(SourceTable)' <> ''
LET vNoOfRows = NoOfRows('$(SourceTable)');
TRACE >>> Number of rows in $(SourceTable): $(vNoOfRows);
LET vNoOfRows = Null();
ELSE
TRACE >>> No table name specified;
END IF
END SUB

tbl:
sql select * from Table123;

call TraceRowCount ('tbl');

[CELAMBARASAN · Accepted solution]

Syntax is like

if condition Then

<logic>

End if

so should be

IF '$(SourceTable)' <> '' THEN