Hello everyone and Happy Holidays
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() ?
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...