CubeSQL SHOW DATABASES

  1. 5 months ago

    David C

    Dec 10 Pre-Release Testers, Xojo Pro Derby, ITM

    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?

    @David C SQLite Manager or CubeSQL Admin

    These two applications use the CubeSQL Plugin provided by SQLabs.

    @David C in my Xojo app (using SQLDatabaseMBS)

    You seem to be facing an issue related to the MBS SQL Plugin. So your best chance is to contact MBS Support.

  2. James D

    Dec 10 Pre-Release Testers Europe (Switzerland)

    Have you tried debugging the code for the admin tool, it is on Github I think.

  3. Jürg O

    Dec 10 Pre-Release Testers, Xojo Pro Answer

    @David C SQLite Manager or CubeSQL Admin

    These two applications use the CubeSQL Plugin provided by SQLabs.

    @David C in my Xojo app (using SQLDatabaseMBS)

    You seem to be facing an issue related to the MBS SQL Plugin. So your best chance is to contact MBS Support.

  4. David C

    Dec 10 Pre-Release Testers, Xojo Pro Derby, ITM

    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.

  5. David C

    Dec 10 Pre-Release Testers, Xojo Pro Derby, ITM

    BTW, it returns the RecordSet with CubeSQLServer, so I have used this as a workaround.

  6. Christian S

    Dec 10 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    Well, the error message comes from CubeSQL.
    Maybe you are not in the right mode to do this.

  7. David C

    Dec 11 Pre-Release Testers, Xojo Pro Derby, ITM

    What do you mean by mode? How do you change modes with CubeSQL — there is no SQLDatabaseMBS.mode=XXX command?

    The CubeSQL manual shows the call as a normal SQL command call.

  8. Christian S

    Dec 11 Pre-Release Testers, Xojo Pro, XDC Speakers Germany

    I thought about wether you use a database or not.
    Not sure if CubeSQL makes a differentiation there

  9. David C

    Dec 11 Pre-Release Testers, Xojo Pro Derby, ITM

    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.

or Sign Up to reply!