If I do sort using controller.sort() in a method, after databaseManager.getDataSetByQuery() function, I am getting an error message saying “Invalid argument: parameter index XX is out of range.”
It would be also nice if sort over not stored calc fields would be possible.
System: Win 2000
DB: DB2 8 EE
Version R2 2.0 rc3-build 263
Why don’t you extend your query with
'ORDER BY "column-list" [ASC | DESC]'
IT2BE:
Why don’t you extend your query with'ORDER BY "column-list" [ASC | DESC]'
Where it is possible to sort direct via selection, I am doing it. But there are certain user interaction tasks where foundset should be re-sorted and it is not working (and it is better/faster just to resort then to select the whole foundset again).
After selecting all records, sort is working.
bruno:
If I do sort using controller.sort() in a method, after databaseManager.getDataSetByQuery() function, I am getting an error message saying “Invalid argument: parameter index XX is out of range.”
To my understanding you are mixing up 2 things, a dataset has nothing todo with a foundset.
It would be also nice if sort over not stored calc fields would be possible.
We leave sorting to the backend database, whats not in there cannot be sorted.