Clicking on the caption header of a grid allows the user to sort the grid. SLX does this on the Server using an appended ORDER BY clause to the executed SQL statement. The SLX OLE DB Provider also rechecks for SECCODE and Field Level Security on the records.

AGAIN.

Yep. When you load the grid SLX checks for SECCODE and Field Level Security on the records.  And when you sort on the server it rechecks the already checked data that has been loaded to the grid previously.

This works fine for up to around 1,500 records. After that, sorting takes a very long time for complex ACCOUNTID/PARENTID hierarchy joins, etc for Non ADMIN users.

 Try an 8,000 record grid sort and then come back from lunch for the results.

Instead.....

Do a client side recordset  sort.....

Grid.RecordSet.SORT "ACCOUNT Asc"

Wickedly fast as compared to the SLX serverside recheck the already checked SECCODE ORDER BY sort.....

And then refresh the grid by recordset (instead of SQL):

SET Grid.RecordSet = Grid.RecordSet

Yes, we've got the code to do all of this, but would be much better if it went native in the control itself instead of trapping MouseDown, MouseUp and grid HitType's.