In the CubeSQL manual it says that I should be able to perform the following CubeSQL commands and return a RecordSet:
SHOW DATABASES SHOW DATABASES WITH DETAILS
When I am logged in as admin via SQLite Manager or CubeSQL Admin, the results are displayed, but when I connect in as admin in my Xojo app (using SQLDatabaseMBS) the same commands return nil with the ErrorMessage:
Command doesn't make sense in current context.
I have tried connecting with and without a named database and get the same response. I am logging in as admin, so I have the privilege to see all database names.
Any clues on what this error might mean?