Hello everyone and Happy Holidays
So I was searching the community for a snippet for student ranking for a system I was building last month but never came accross a what I needed. I found a JavaScript on stackoverflow and re-wrote it in b4x
So I'm sharing for future/existing members who may need...
Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ?
e.g.
Dim RS As ResultSet=Sql1.ExecQuery($"SELECT ROW_NUMBER () OVER ( ORDER BY cid ) RowNum, ostatus, cid, itemcount FROM orders;"$)
Error in Log:
DBeavear and DB Browser for SQLite...