recno() and rowno()

[tripatirao]

Hi all

I know  how recno() and rowno() works but I dont know where to use which

function.

Thanks

[swuehl]

Use RecNo() when you want to create a counter for the input table and RowNo() when you want a counter for the output table.

[tripatirao]

Hi

Can you explain with exemple

thanks in advance

[Anonymous]

Hi Tripati,

Rec No () and Row No () – sequential record number generated for number of rows in source table. Behaves differently when where clause is used.

please follow below posts:

RecNo or RowNo?

RecNo or RowNo?

[tripatirao]

Hi neetha

What is the use of RecNo() in below script

Load

RecNo()-1+Floor(MakeDate(2012)) As TempDate

AutoGenerate(730);

Thanks

[Anonymous]

hi tripati,

it generates sequential days upto 730 days is reached.

starting from 1st jan 2012

[Gabriel]

Hi,

I think a brief explanation of what you want to use these functions for might help.

[tripatirao]

Hi neetha

I want to know the difference between below 2 expression.

Load

RecNo()+Floor(MakeDate(2012)) As TempDate

AutoGenerate(730);

and

Load

RecNo()-1+Floor(MakeDate(2012)) As TempDate

AutoGenerate(730);

The 1st expression is also generating date upto 12/31/2013.

Regards

Tripati

[Ralf-Narfeldt · Accepted solution]

For the first record read, RecNo() will be 1. This means that:

RecNo()+Floor(MakeDate(2012)) = 1 + 01/01/2012 = 01/02/2012

RecNo()-1+Floor(MakeDate(2012)) = 1 - 1 + 01/01/2012 = 01/01/2012

So, the first one will start at 2 Jan 2012 and generate 730 days

Second will start at 1 Jan 2012 and generate 730 days

[tripatirao]

Thanks all,I got the point.