Not sure if this a bug . Instead of using Postgres to test with an iPad I have moved to SQLite ( using SQLite Manager btw) .
The database is dragged to the Asset folder and two order queries are made. Using the previously discussed code I have sorted the same data but encounter the error message " Unable to find orderbyid into class CREODatabaseSQLite " where the Asset datafile is named HealthCanadaDrugs. MasterTable.dataSet = HealthCanadaDrugs.orderbyid; caused the runtime error.