Tim

Would it be possible to have somewhere to define the default column widths used to present a query. In the sub-totalling one I'm working on I have to keep on resizing them to see the output. I suppose its because the UNIONs make it difficult for EDBManager/EDBDatabase to figure out what they are from the columns.

Roy Lambert

I second that.  Or better yet, automatically resize them based on the widest
content (up to a maximum).

Sometimes I'll find an average of 20 characters in a 100-character field.
That's usually when I'm looking at customer data and I've given the customer
more space than they actually need.

--
David Cornelius
Cornelius Concepts

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:157CC8E6-903A-4071-A0BD-C6BADF0E8BEB@news.elevatesoft.com...
> Tim
>
> Would it be possible to have somewhere to define the default column widths
> used to present a query. In the sub-totalling one I'm working on I have to
> keep on resizing them to see the output. I suppose its because the UNIONs
> make it difficult for EDBManager/EDBDatabase to figure out what they are
> from the columns.
>
> Roy Lambert

Roy,

<< Would it be possible to have somewhere to define the default column
widths used to present a query. In the sub-totalling one I'm working on I
have to keep on resizing them to see the output. I suppose its because the
UNIONs make it difficult for EDBManager/EDBDatabase to figure out what they
are from the columns. >>

The column sizes are determined by the end result set and the base TDataSet
functionality in the VCL.  Are you totalling floating-point fields ?  If so,
then that is most likely the cause of the issue.  You can get around that by
using the ROUND() function to round the results to a specific number of
decimal places.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

>The column sizes are determined by the end result set and the base TDataSet
>functionality in the VCL. Are you totalling floating-point fields ? If so,
>then that is most likely the cause of the issue. You can get around that by
>using the ROUND() function to round the results to a specific number of
>decimal places.

Nope, the result set consists of integers or strings.

Roy Lambert

Tim


Just checked and its the string fields that are "oversize"

Roy Lambert

Roy,

<< Just checked and its the string fields that are "oversize" >>

By how much ?  The default max string field size is 60 characters in the EDB
Manager, so it should extend up to that point with no problem.

Also, is this XP or Vista and higher ?

--
Tim Young
Elevate Software
www.elevatesoft.com

What I would like to see along this line, is the column widths of a table
saved so that next time the table is opened, the column widths are
remembered.  It'd be nice to extend this functionality to a saved query.

I have a terms field where most of the terms are short, but once in a while
I'll see a very long one.  I'd like to keep the terms field narrow because
other fields are more interesting.  Same thing with email.

--
David Cornelius
Cornelius Concepts

"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message
news:157CC8E6-903A-4071-A0BD-C6BADF0E8BEB@news.elevatesoft.com...
> Tim
>
> Would it be possible to have somewhere to define the default column widths
> used to present a query. In the sub-totalling one I'm working on I have to
> keep on resizing them to see the output. I suppose its because the UNIONs
> make it difficult for EDBManager/EDBDatabase to figure out what they are
> from the columns.
>
> Roy Lambert

Tim

>Also, is this XP or Vista and higher ?

Vista.

Roy Lambert

David

>What I would like to see along this line, is the column widths of a table
>saved so that next time the table is opened, the column widths are
>remembered. It'd be nice to extend this functionality to a saved query.

Check out the .ini and you'll find column, sequence & widths are stored.

Roy Lambert

Tim


Just a thought. If you want I'll email you some code that adjusts the column widths to fit the space available. Its so far been incorporated into Mike Skolnik's dbgrid and TMS's AdvStringGrid. Add a couple of buttons, one to fit to width and the other to go back to normal.

Roy Lambert