Re: [Squirrel-sql-develop] Column Widths in Squirrel

Hi Stephen,

> I recently downloaded SQuirreL SQL and have found it to be one of 
> the best
> open source Java-based SQL tools around.

Thank you. Most of the credit goes to the people who have contributed to
1.1. If you compare 1.0 to 1.1 it makes me embarressed to admit I
released 1.0.

> In the createDataSet() method, change
> 
> rsds.setResultSet(rs,
> getSession().getProperties().getLargeResultSetObjectInfo());
> 
> to
> 
> rsds.setResultSet(rs,
> getSession().getProperties().getLargeResultSetObjectInfo(), new 
> int[] { 4,
> 6, 7, 9, 18, 13, 12 });

Its a funny old world, originally (quite a long time ago) this code
was in Squirrel but I took it out as at least one person was having
problems with a JDBC driver that threw an error if a column was missed
when retrieving data from a metadata resultset. I never tracked
the problem down (frankly I didn't have the time to spend on it) as
the intention was to have a UI that would allow you to specify which
columns in each of the metadata displays you wanted. Needless to say
this didn't make it into 1.1. What I should have done (and its only
just occurred to me now that I've released 1.1) was to have a setting
"Show only interesting data in metadata displays" (needs a better
name) that if checked would do what you've suggested for all the
metadata displays.

I'll put this into 1.2. Don't worry it won't take another year for the
next release. The idea is to do smaller faster releases in the future.

> I would be interested in adding features to the pop-up menu for 
> the Content
> tab, to allow the user to Select N rows, and to add tooltips to column
> headers, so that you don't have to expand the column to see the 
> full column
> name.

Go ahead! The more people help, the better Squirrel gets. Just send me the
diffs against the latest CVS version in the SQuirreL-sql module and I'll
apply
them to CVS.

--
Colin Bell
http://squirrel-sql.sf.net