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.
I thought it might be MBS related, but wanted to dismiss any logical issues first, since I would have thought SQLDatabaseMBS would just pass-through the SQL command and back with the RecordSet without evaluating it in any way.
Good suggestion, but I’ve tried the command both when I’ve connected to the server with a defined database and when none is define, with the same response.