Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
Syntax is like
if condition Then
<logic>
End if
so should be
IF '$(SourceTable)' <> '' THEN
Syntax is like
if condition Then
<logic>
End if
so should be
IF '$(SourceTable)' <> '' THEN