So I discovered that the new FM8 function:GetNthRecord ( fieldName ; recordNumber ) there was into FM7 too !

Its name is: GetRowData ( fieldName ; recordNumber )

But it do nothing, neither appears between the functions list.

If you enter a calc with this, FM7 accept the function !

If you open with FM8 you'll see the new one !

So (for now I think, I didn't test), if you write a custom function with FM7 Dev around this , when you'll open with 8 it should work :

Ok

---------tested--------------------

Now I can make a custom function with FM7 Dev and look how it works with FM8 trial :laugh:

Daniele, how on earth did you figure out that this function exists in FM 7?

Create a file in 8 that uses the GetNthRecord function, then open it in 7. You will see GetRowData in its place.

Nice easter egg! Too bad it couldn't have been found earlier.

But it doesn't behave properly in 7, does it? In my test it returns the value of the current record, not the Nth.

No. Apparently the concept was not fully fleshed when 7 was released. I think Daniele's point was that you can use it in 7 to be prepared for use in 8. I do not have veresion 8, but I can make a sample file which includes GetNthRecord for someone else to use in 8. That is quite nifty.

"But it do nothing, neither appears between the functions list."

As I said this function IS into FM7 but makes nothing!

So it seems not a great discovery...

but if you own FM7 Developer, than you can make a custom function with this new function.

When you'll open that file with FM8 (not the advanced ! the trial is just good !) the custom function will run !!

Edited October 7, 200520 yr by Guest
other words to explain better

So, if you're like me, and very poor at Custom Functions, what exactly would one need to do to use this?

Hi

I made this file (as an example) with FM7 Dev;

there is a custom function:

Field'sAllData(field;number)

Let([

next = number + 1

];

Case(

number < Get ( FoundCount )  ; GetRowData ( field ; number ) & "¶" & Field'sAllData ( field; next );

number = Get ( FoundCount )  ; GetRowData ( field ; number );

""

)

)

This file do not work with FM7...

but it will work with FM8 !

GetRowData.zip