Variable creation

[#1]

I wrote script to create the tables and the relationship, but i cannot figure out how to create a variable and assign to it the number of rows of a specific table.

I need this when creating a percentage graph.

[swuehl]

Are you looking for something like this?

TABLE:

LOAD * INLINE [

Test

A

B

B

C

C

C

];

LET vNumRows = NoOfRows( 'TABLE' );

[#3]

ok i did all this and created vNumRows in settings => variable overview.

but when i want to show this in a text object, it appears as NoOfRows( 'TABLE' )  not a number

how can i fix this???

Thanx  for the reply

[jonathandienst]

Hi

That form of NoOfRows is only usable during script. If you want to display it in the front end, use Stefan's script to create a variable, and then display the variable value. Put

=vNumRows

in a text box.

Regards

Jonathan