Distinct function?

[CryoGen]

In the SQL world I can run write a query with a DISTINCT argument to aggregate values in a particular column. Does FMP have a similar function? I need to be able to set all the possible values in any given field into a global field.

I know it's possible to export values from a field once they been sorted and summarized, but I need the values to be available within the application (not in an exported file).

Can this be done recursively through a custom function? Any idea on what it would look like (or is that overkill?)

 

[JeanW]

As far as I can see, and not knowing the why, you need to script it.

See how far you can go with Get(ActiveFieldContents) and a set field script in a loop.

 

[JeanW]

On the other hand, if you want a Custom Function, I would look at the new GetNthRecord() function in FM8, if you have 8A.

You could make something along these lines:

Case ( currentRecordNumber < Get ( FoundCount );
GetNthRecord ( yourField ; currentRecordNumber )
& ¶ & CFName( yourField; currentRecordNumber + 1 );
currentRecordNumber = Get( FoundCount );
GetNthRecord ( yourField ; currentRecordNumber )
)

Within this function you only need the value from yourField and currentRecordNumber

HTH