Return to FileMaker.com
I am finding that when referencing a MySQL view via a TO and ESS, the row order specified on the view is ignored and the rows are rendered unsorted?
Can you see the actual ESS query in your MySQL Log?
"ORDER BY is permitted in a view definition, but it is ignored if you select from a view using a statement that has its own ORDER BY"
> the rows are rendered unsorted
Retrieving data ...