I have a foundset, loaded by loadRecords(sqlString, sqlParams). In the sqlString, I have (as required, and desired) an ORDER BY clause. When the loaded foundset is shown, all is good and the order is as specified/desired.
But… when I invoke print-preview then the foundset changes to a different order (default of foundset table’s PK?)
No, I can’t sort in Servoy as the some of the fields in the ORDER BY are five joins away.
Any suggestions?
Thanks,
Neale.