Hello!

I wounder if there is a way to get out what diffrent kinds of values there are in a filed? If I have 4000 Records with either 1 or 2 in a field called "number" then I just whant to get a list with 1,2. A list with the different types of numbers entered..

Regards Jocke

You can create a value list based on your field. The value list shows unique values. Then you can parse the listitems in the value list to use the unique values.

Once you have your value list, create an unstored text calculation of

Substitute( ValueListItems( Get(FileName); "yourValueListName" ); ¶; ", " )

Thanx!

It worked like a charm! U rock!

// Jocke

When u have a field with the list containing 1,2,3 and so on... how do I get out the first value to a temp field and do something with that, then the next value and do something with that and so on? Anyone got any clues?

// Jocke

In version before 7, I have used one of the design function valuelistitems(dbname,valuelist). This would return you all the values. I believe you can write a script using a global variable:

setfield(gCount)=1

setfield(gValueListItem)=""

loop

gValueListItem = middleword((ValueListItems("dbname" ,"ValueListName" )),gCount,1)

Process field gValueListItem.

setfield(gCount) = gCount + 1

exit loop if(gCount > WordCount(ValueListItems("dbname" ,"ValueListName" ))

end loop

I did a script like this:

SetVariable($no;Value:1)

Loop

Exit Loop If($no > WordCount(ValueListItems(Get(Filnamn); "Get_Languages" )))

SetField(tempcalc;MiddleWords((Image::Unique_Languages);$no;1)

SetVariable($no;Value:$no +1)

End Loop

Must say that ur sudgestion helped me ALOT! BIG thanx!!!

Regards Jocke

If Anyone whants to talk FM add me: [email protected]