>>...
>>>There' no bug here so there's nothing to explain. Using RECNO() incorrectly doesn't help either.
>>
>>Then, is this incorrect ?
>>

>>SELECT RECNO() rowNumber FROM myTable
>>

>
>What it has to do with our discussion? Where is UDF() here?

UDF is irrelevant here, however you answer to both

1 is correct this for you ?
SELECT RECNO() rowNumber FROM myTable
2 is correct this for you ?
SELECT UDF(RECNO()) rowNumber FROM myTable