CubeSQL SHOW DATABASES

  1. last year

    David C

    10 Dec 2018 Testers, Xojo Pro, XDC Speakers 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

    10 Dec 2018 Testers, Xojo Pro Europe (Switzerland)

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

  3. Jürg O

    10 Dec 2018 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

    10 Dec 2018 Testers, Xojo Pro, XDC Speakers 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

    10 Dec 2018 Testers, Xojo Pro, XDC Speakers Derby, ITM

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

  6. Christian S

    10 Dec 2018 Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

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

  7. David C

    11 Dec 2018 Testers, Xojo Pro, XDC Speakers 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

    11 Dec 2018 Testers, Xojo Pro, XDC Speakers, Third Party Store Germany

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

  9. David C

    11 Dec 2018 Testers, Xojo Pro, XDC Speakers 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!