How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

how to define a title for a resultset (feature request)

[This topic is migrated from our old forums. The original author name has been removed]

Hi, is it possible to assign a title to a result set? I cant find anything. This would be a great feature (for me). Another feature would be an xls/odt export which exports all open resultsets into a single document. And it would be helpful when autocompletion would check the searchpath for elements when not specifying a schema including current temp schema to select temporary objects like tables or views. I'm refering PostgreSQL mode. btw its a great tool Thomas
7 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Thomas, Really appreciate your suggestions. I will add them in our feature request database. Thanks! Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: how to define a title for a resultset (feature request)
Hi Roger, and I have more ;) for import table: features: * file filter should default to *.csv * import from odt/xls * allow save configuration per file * modify multiple columns at once (assign same datatype to selected columns, specify nullable aso) bugs * for PostgreSQL: assign data type 'text' to CLOB, currently its unknown * import a file, restart dbvis, delete this file, open dialog 'Import Table Data' and press cancel. An error is shown that the file does not exist
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Thomas, A follow-up regarding export to XLS and multiple result sets. This is supported already using the @export client side command in DbVisualizer. An example: @export on; @export set filename="C:\out.xls" format="xls" appendfile="true"; select * from t1; select * from t2; select * from t3; @export off; Read more in: http://www.dbvis.com/products/dbvis/doc/main/doc/ug/sqlCommander/sqlCommander.html#mozTocId448386 Regards Roger
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Thomas, > features: > * file filter should default to *.csv > * import from odt/xls > * allow save configuration per file Will add these as feature requests. > * modify multiple columns at once (assign same datatype to selected columns, specify nullable aso) > bugs In the last pane where imported data is mapped to database table you can use Copy/Paste to set datatype, etc on all selected cells. > * for PostgreSQL: assign data type 'text' to CLOB, currently its unknown We will look into this. > * import a file, restart dbvis, delete this file, open dialog 'Import Table Data' and press cancel. An error is shown that the file does not exist I am unable to reproduce this. Am I missing a step based on your walk-through or are these all the steps you did to get the error? Regards Roger
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Hi Thomas, Just wanted to tell you that the issue with the file filter default is now fixed in the just released 9.0 version. You can also save and load settings from a file: http://www.dbvis.com/doc/relnotes/?version=9.0 Best Regards, Hans
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Thomas, I just want to inform you that Excel import is now available in the beta version for the upcoming 9.2 version. http://www.dbvis.com/download/beta/ Regards Roger
[This reply is migrated from our old forums.]

Re: how to define a title for a resultset (feature request)
Thomas, DbVisualizer 9.2 has just been released with support for importing XLS/XLSX files and a command to set the name of the next result set in the SQL Commander. http://www.dbvis.com/doc/relnotes/?version=9.2&showtoc=false Regards Roger
Comments to this discussion are now closed!
More topics in Support
See all 1297 topics