Using "Order by random()"
CasanovaGregory opened this issue · 3 comments
Hi,
I'm trying to use the random function of Sqlite and I'm facing some problem. Is the random function supported in the plugin ? I'm using it like this :
SELECT * FROM products ORDER BY RANDOM()
In an editor like "DB Browser for SQLite" it works, but not using the plugin...
I get the following error :
"code: 5, message: "could not prepare statement (1 not authorized to use function: random)"
Any reason ?
Thank's a lot !
Are you using Web SQL? I found the following: http://stackoverflow.com/questions/30036628/could-not-prepare-statement-1-not-authorized-to-use-function-random
I was using it on Google Chrome so I assume that I was using web SQL.
Will it work on a device ?
This is an enhancement for future consideration and will need some additional testing. Here are some resources: