Database Connection in the IDE

Mod if this should be moved to Database section please do

Xojo 2024 3.1 Windows 10 and 11.

In the Xojo IDE you can insert DB connection for target DB, set Development-Beta-Release, set all the connection properties and click connect. OK all that works great with MySQL and SQLite. My question is the Enter SQL Command right side of connect button. It opens small window to enter SQL command, has Execute button but does not seem to do anything but keep a list of previous executed SQL statements.

Is this button supposed to execute the SQL command somewhere? Has anyone had success?
I tried with MySQL and SQLite, both on localhost.

Just wondering as I have tried this in previous releases and had same results, if I hit Execute button a few times it will cause disconnection of DB and then a fatal error message and shut down the IDE.

I looked up the functionality in the docs but found nothing on the Execute SQL button.

Thanks :grin:

@William_Yu

:grin:

Sounds like a bug, please file an Issue if one hasn’t already been filed, thanks.

1 Like

Will do and thanks for replying

:grin:

And submitted

https://tracker.xojo.com/xojoinc/xojo/-/issues/78013

1 Like

Marked fixed for 2025 R1 :grinning:

Thanks @William_Yu