I have created a VIEW in my database from which my app selects records based on various criteria entered by the user
It builds a QUERY from what the user enters… and tacks “ORDER BY lastNAME,firstNAME,birthdate” on the end
the most basic query would be
SELECT * FROM quickData ORDER BY lastNAME,firstNAME,birthdate
HOWEVER, the records to NOT come back in that order, the come back in the physical order they were entered.
If I use TADPOLE to execute the query… it returns the correct results?
Any ideas?
PS. there are no database errors