Ways to number of rows in current dataset.

[#1]

Hello Everyone,

Is there any way to find the number of rows in a dataset that I am currently using to build the application.

Because I have testing an application and the user's dataset has 21000 rows and he asked me what is

my testing dataset. But I am directly using the application to test the result, so I have no clue nor do I

have any understandings how to do it.

Please help,

Regards,

Bikash

[jduenyas]

Create a Table Object and insert the fileds $Table and $Rows.

Thant will show you how many tables and how many rows for each are in your database

[#3]

In your load add in a field called Count_Up and put a 1 in it then jsut sum(Count_Up) to get number of records

[#4]

I know the two fields $table and $rows but how can I adress them to read values from them in the script?

What Is the name of the underlying System-Table?

Kind regards

Chris

[rwunderlich]

You can't access $Table & $Rows in the script. They don't exist until script end.

In script, you can get the number of rows using the function:

NoOfRows('tablename')

-Rob

[#6]

Hope it helps:

1. To find no of rows in a previously loaded table

NoOfRows('TableName')

2. To find no of fields in a previously loaded table

NoOfFields('TableName')

3. To find no of tables loaded

NoOfTables()

[#7]

Please let me know which of the solution makes sense...