Relation count function

Classic Servoy
1

Servoy’s databaseManager.getRecords(relation) function will give me a true or false on whether loading the relationship will produce results. However I’m looking for a record count function, something equivalent to FMP’s Count function.

If (Count(relation) = 0))
do this
else
If (Count(relation) = 1))
do something else
else
If (Count(relation) >1))
do something completely different
Endif
Endif
Endif

Is there an efficient way to do this in Servoy?

2

Hi Morley,

You can use this function which is under Forms → ‘formName’ → Relations → ‘relationName’ in the method editor :

relationName.getSize()

Cheers
Harry