Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 10 of 18 total |
EDBManager column widths |
Fri, Apr 30 2010 7:58 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Apr 30 2010 11:16 AM | Permanent Link |
David Cornelius Cornelius Concepts | 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 |
Fri, Apr 30 2010 11:22 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Apr 30 2010 11:28 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Fri, Apr 30 2010 11:38 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
Just checked and its the string fields that are "oversize" Roy Lambert |
Fri, Apr 30 2010 1:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Apr 30 2010 3:23 PM | Permanent Link |
David Cornelius Cornelius Concepts | 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 |
Sat, May 1 2010 7:50 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tim
>Also, is this XP or Vista and higher ? Vista. Roy Lambert |
Sat, May 1 2010 8:00 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, May 1 2010 8:05 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Page 1 of 2 | Next Page » | |
Jump to Page: 1 2 |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |