I use ORDER BY name ASC Sqlite command in my code, for getting form names in alphabetical order, it works on Desktop environment but on mobile devices (iOS,Android) it doesn't work.
Full select code is this
Code: Select all
put "SELECT * FROM form INNER JOIN icons ON form.iconid = icons.iconid ORDER BY name ASC" into tSQL
put revQueryDatabase(sDBID, tSQL) into tCursor
put dbSQLToArray(tCursor, tFormArray) into tError
if tError is empty then
return tFormArray
end if
Any suggestion will be helpful.
Thanks,
Armenuhi