subfile sorting & data driven subfile
Posted: Thu Apr 30, 2015 3:04 pm
I want to have a subfile with column sorting capability.
Subfile sorting only sorts the records loaded into the subfile at the time you click the sort. That makes sense. so I need to load the entire subfile in order for sorting to work effectively. Or pass the column sort response fields back to the server... which I'd rather not do because it's a lot more work.
If I load the whole subfile it will be more than 9999 rows, so I need to use a database driven subfile grid.
However, I can't tell how to return to the RPG program the record or records that the user selects. Since the subfile is built on the client side, the server isn't aware of record numbers or what's loaded into them. so I will need to return all of the fields of the selected record(s).
Is this possible? And does someone have an example of how to do this?
Subfile sorting only sorts the records loaded into the subfile at the time you click the sort. That makes sense. so I need to load the entire subfile in order for sorting to work effectively. Or pass the column sort response fields back to the server... which I'd rather not do because it's a lot more work.
If I load the whole subfile it will be more than 9999 rows, so I need to use a database driven subfile grid.
However, I can't tell how to return to the RPG program the record or records that the user selects. Since the subfile is built on the client side, the server isn't aware of record numbers or what's loaded into them. so I will need to return all of the fields of the selected record(s).
Is this possible? And does someone have an example of how to do this?