SynDb Explorer - Cannot execute multiple statements at a time?

edwinsn · 2014-08-21 06:33:25

Arnaud,

SynDb Explore, if you execute multile sql statements separated by commas, it'll run only the first statement. Eg:

delete from table1;
delete from table2;
delete from table3;

Another problem: The buttons need to be larger, check the screenshot:

ab · 2014-08-21 06:46:15

The tool executes one statement at a time.
This is by design.
We want each statement to be explicitly run and its result checked.

But you can select a statement in the memo, and only the selected text will be executed.
Use the keyboard to select a line (shift + arrow down), then press F9 to execute the statement.
Then go to the next line (arrow down), select the line (shift + arrow down), then press F9 to execute the new statement.

The buttons are meant for a normal default font size of Windows.
You did change the font dpi of your screen.
We won't change the button size just because of your own screen settings.
AFAIR we already put a property of the main form of this tool to "Scaled := false", to fix the problem.
Ensure you are using the latest 1.18 version.

edwinsn · 2014-08-21 07:36:19

Arnaud,

Ok, I'll use the keyboard shortcuts.

Just a note: "Scaled := false" only solves the previous "font size problem", but not this "button size problem".

ab · 2014-08-21 13:28:22

I do not understand the problem.
If the font has its default size, it will fit in the button.
So you won't have to resize the button.
We won't change the button size just because of your own screen settings.

Or is there some generic VCL-level workaround I do not know about?

edwinsn · 2014-08-22 06:49:44

Just to clarify, I'm not suggesting the button size change because my own screen setting, but because the program doesn't fit various DPI settings allowed by the Windows system

I think the problem is that, by setting "Scaled := false", you by pass VCL's own scaling and allow the Window system to decide the font size, and Windows will consider my custom DPI setting, so the font sizes (40% larger) match my system. But since Windows doesn't decide the size for your buttons, if the buttons are designed too small, the font will overgrow.

ab · 2014-08-22 07:56:05

AFAIR Scaled := true was not good either.

So what is the solution?

edwinsn · 2014-08-22 15:13:36

ab, if you take a look at the buttons in the Windows standard 'Open File' dialog, there are enough spacing inside the borders and around the button caption, which provides "buffer" for the font size to grow, unless you set system DPI to some crazing value say 300%.

So it's very simple - use the form designer to make the buttons a little larger at design time I should have done this and contribute back if I know Fossil well

And taking about Fossil, can we use github to collaborate, in a future time I want to contribute something, which will benefit all, but are not a high priority in your list? I don't know github very well either, but I think it's workflow is quite straightforward - fork, checkout, change the code, submit and send a pull request to the master branch (ie your repository). I'm not sure if that will work for you?

ab · 2014-08-22 19:16:44

From my own experiment Fossil is easier to work with than Git, if you know how to use the Windows command line (either with some .bat), or with TotalCommander (as I do use).

But we made the github repository for the purpose of forking and third-party contributions.
We would accept any contribution from github, also, of course.

mORMot Open Source

#1 2014-08-21 06:33:25

SynDb Explorer - Cannot execute multiple statements at a time?

#2 2014-08-21 06:46:15

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#3 2014-08-21 07:36:19

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#4 2014-08-21 13:28:22

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#5 2014-08-22 06:49:44

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#6 2014-08-22 07:56:05

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#7 2014-08-22 15:13:36

Re: SynDb Explorer - Cannot execute multiple statements at a time?

#8 2014-08-22 19:16:44

Re: SynDb Explorer - Cannot execute multiple statements at a time?

Board footer