GetRowData ( fieldName ; recordNumber )

[Raybaudi]

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 :

[Raybaudi]

Ok

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

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

[Kent Searight]

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

[-Queue-]

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

[mr_vodka]

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

[Kent Searight]

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

[-Queue-]

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.

[Raybaudi]

"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, 2005 by Guest
other words to explain better

[Elwood Blues]

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

[Raybaudi]

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