What's wrong with this script?

[nox]

I'm trying to use this calculation to find out if we are on the last record in found set or not. But somehow it doesn't work. I can't figure out why. The field is dynamically generated so it can be reused on other tables.

Let(



$field = Get ( LayoutTableName ) & "::ID";



If (



GetNthRecord ( $field; Get ( RecordNumber ) + 1) = "?";

1;0)



)

Thanks in advance for your help!

[Raybaudi]

Try with this calculation ( the $field isn't needed if the field name is always "ID" )

not IsValid ( GetNthRecord ( ID ; Get ( RecordNumber ) + 1 ) )

[bruceR]

Get(recordNumber) = get(foundcount)

[Raybaudi]

Of course

( I was intrigued by its search for "?" )

BTW: each calculation must be unstored.

[nox]

Ah that was so easy! Doh!

Thank you both guys!