count number of rows


i need a variable with the number of rows of a table.

The table may not exists therefore I can't execute a database reader on it (in this case the variable must be equal to 0).

If i use a try-catch with a database reader and a java snippet, the variable set into the branch is not visible outside.

How can i resolve this problem?



Hi Darbon,

put the database reader only into the try catch and give the second inport of the catch node an empty table. The java snippet after the catch will then return 0 for the empty table.

Cheers, Iris