sqlite SELECT with ORDER BY not working

Solar2D Lua Language
#1

Hi,

I am trying to do a query like this

SELECT pe_id, pe_name, pe_lastname, pe_image, pe_rawname FROM wkpeople ORDER BY pe_rawname

it works perfectly from sqlite3 but when executed from Corona it returns the first entries based on their id, not the pe_rawname filed.

Is it a bug?

thanks
[import]uid: 9304 topic_id: 2332 reply_id: 302332[/import]

#2

I kind of figure it out.

The problem is that pe_id is the PRIMARY KEY.
The moment I changed it so it’s not a primary key it worked.

Not sure if it’s a bug or not.
[import]uid: 9304 topic_id: 2332 reply_id: 7136[/import]

#3

We would need to see how you set up the sql…

any additional code you could share would be helpful

you could email it to info at anscamobile.com

carlos [import]uid: 24 topic_id: 2332 reply_id: 7146[/import]