I have a database with 120,000 rows. I can’t select any record higher than 65536. It appears to be the maximum row that can be accessed in Corona.
[import]uid: 82085 topic_id: 28791 reply_id: 328791[/import]
I would suggest building a small sample test and file a bug report. Corona Labs will ask you for that before they pursue it.
[import]uid: 19626 topic_id: 28791 reply_id: 116100[/import]
This is just a heads-up so another user doesn’t waste as much time as I did trying to figure out why, for example, Razor SQL can access records that Corona can’t.
I split the large table into two smaller tables < 65K and I’m handling it that way.
If the Corona staff wanted to fix it, they could generate a DB with 70K records with nothing more than a sequential numeric key field and then try to select records by that field. They would see that in Corona the select works up to record number 65536 and it fails for every record after that.
[import]uid: 82085 topic_id: 28791 reply_id: 116111[/import]