After the rest of the morning not getting it to work, i did something else.
I created a calculated field in the result query, and store the row number from the db, and not the recno. It is only the row number from the db that is valid.
I can not use any fetching of data with IZResultset or DBCResultset when sorting. So this is just no way.
The result sets will not work on undirectional results with sorting. It will not either match the row number to the query.
So, the IZResultset is just broken i would say.
I have to use the IZResultset together with the created calculated field from the query. That means also the result set is never sorted, but the query set is. And also have to work with two different result sets at the same time.
This was not good.
But this solution is working, and will work on any DB engine.
But spending all night and half of the day on this was not any fun.
The special result sets in Zeos is just not any good. Maybe i am missing something, but can't fix it. and super little info on the web.