Problem sorting with relation

Hi

I have a problem, sorting a foundset via relation. The relation is between two tables in different databases. I do not get an error, but I do not get a sorted foundset either.

Does Servoy support sorting via relations between databases?

Regards
Birgit Rieder

Birgit,

Servoy executes the sort in the database.
This only works if all tables involved are in the same database.

We do have an in-memory-sort on foundset, foundset.sort(Function), which you can use to sort outside of the database, but this will read all records in memory.

Rob

Thank you for the answer.
Regards
Birgit