Topic: SQL query working outside but no in MVD
Using the below query I am trying to populate the data in dropdown which list the list of tables in sqllite db.
SELECT ROW_NUMBER() OVER (ORDER BY name) as id, name FROM sqlite_master WHERE type="table"
But this is working if run i sqlite manager. But in MVD its show as syntax error.
How to get this query running in MVD ?