User Activity

  • Modified a comment on ticket #620 on SQuirreL SQL Client

    Hello, Gerd, I have tested this RFE and this works as I understood and expected. From my point of view this Ticket could be Closed as Implemented. Just few notices: 1) I do not understand, why exporting of SQL command export is disabled for interactive Export. It could be useful as an evidence how the data were exported. Once there is such possibility, why not to allow checkbox even for interactive export. 2) When using interactive Export window, there is no right side scroll bar. And for example...

  • Posted a comment on ticket #620 on SQuirreL SQL Client

    Hello, Gerd, I have tested this RFE and this works as I understood and expected. From my point of view this Ticket could be Closed as Implemented. Just few notices: 1) I do not understand, why exporting of SQL command export is disabled for interactive Export. It could be useful as an evidence how the data were exported. Once there is such possibility, why not to allow checkbox even for interactive export. 2) When using interactive Export window, there is no right side scroll bar. And for example...

  • Posted a comment on ticket #621 on SQuirreL SQL Client

    Hello, I tested Oliver's and my RFE of this Ticket with SQuirreL SQL 20250609_2217-standard using Adoptium OpenJDK 17.0.14+7 on MS Windows and from my point of view both work very well. I am satisfied. I think, this Ticked can be closed as Implemented. But I am not Creator nor Owner of this ticket, so I can not close it. Thank You, Stepan *P. S.: Strictly saying CSV differs between numeric and other datatypes. Numeric ones should not use Cell delimiter, even it is defined, but then it could be a...

  • Modified a comment on ticket #621 on SQuirreL SQL Client

    Hello, and once (if) You will change this part of code, I would like to have not only header as Oliver wants, but also add custom user delimiter field (usually double quote) and custom user escape character of delimiter character (usually double quote too) - the same logic as in Export to CSV. Currently I am using Export to CSV to bypass these two missing delimiters, which is quite fine for me, but could be better once implementing most of CSV specification (for example as H2 database does, see https://www.h2database.com/html/grammar.html#csv_options...

  • Posted a comment on ticket #621 on SQuirreL SQL Client

    Hello, and once (if) You will change this part of code, I would like to have not only header as Oliver wants, but also add custom user delimiter field (usually double quote). Current tricky output and desired output one can see below. Thank You, Stepan select 'a b', 1, 2, 'c; d' union all select 'e f', 3, 4, 'g; h' --no doublequotes produces wrong column count, because Cell delimiter is a part of string inside the last column: a b;1;2;c; d e f;3;4;g; h --current tricky delimiter using doublequotes...

  • Posted a comment on ticket #620 on SQuirreL SQL Client

    Hello, please just keep in mind, that SQuirreL has a great feature, that it can export multiple ResultSets each into separate Excel Sheet both from GUI and or from SQuirreL's meta languague. So in case one want to save also SQL SELECTS (commands) into separate one sheet, there has to be solved how and where these SQLs will be saved in the output. If all commands one below another in one Sheet or each ResultSet data sheet will have its own another SQL sheet next to it. Or if SQL Command will be saved...

  • Posted a comment on ticket #1532 on SQuirreL SQL Client

    Hello, I tested export to CSV on another (my private) comp Win11 just now, running under no admin, the latest Adoptium JDK 23 and CSV and XLSX works for me fine. Yes, I have JDK, no JRE and inside it Java FX from Gluon, but it should not affect this behaviour, I hope. Regards, Stepan

  • Posted a comment on ticket #1532 on SQuirreL SQL Client

    Hello, Vikaash, I also tried Eclipse Adoptium OpenJDK Runtime Environment 23.0.1+11 on Windows Server 2016 and squirrel-sql-snapshot-20241208_2056-standard.jar and export to CSV nad XLSX works for me OK. Files are created, dialogue is responsive, files are opened in LibreOffice and MS Excel both OK. So it may be a problem in some configuration, I guess. Regards, Stepan --H2 2.3.232 InMemory drop table if exists "t" ; create table "t" ("price" numeric (10, 2), "purchaseDate" timestamp); insert into...

View All

Personal Data

Username:
t603
Joined:
2001-09-03 13:30:41
Location:
Prague / Czech Republic / CEST
Gender:
Male

Projects

This is a list of open source software projects that Stepan RYBAR is associated with:

Personal Tools

MongoDB Logo MongoDB