help with a calculation

[alimrb]

hello, i would like to have a globale calculated A field that contains all of B field's contents in current found set in this format:

A=B1

B2

B3

B4

...

A and B are in a same table, how can i do it?

Edited February 28, 2006 by Guest

[alimrb]

an answer?

[Raybaudi]

Hi

if you want that the global field A shows all the values of field B in the found set of records in this manner:

B1

B2

B3

...

B (last of the found set)

you can do it with a *recursive* calculation (NOT STORED and NOT GLOBAL)that use a custom function like this one, but you'll need FM8 Advanced;

--------------------------------------

Recursive(field;number)

Case(

number < Get ( FoundCount ) ; GetNthRow( field ; number ) & ¶ & Recursive ( field ; number +1 ) ;

GetNthRow( field ; number )

)

--------------------------------------

or

with a script like this ( to use after a FIND)

Go to Record/Request/Page [First]

Set field [A;B]

Loop

Go to Record/Request/Page [Next: Exit after Last]

Insert Calculated Result [A; ¶ & B]

End Loop