DefExpressionColumnWidth etc have to be set BEFORE the database connection is opened otherwise they have no effect
As the subject says ! :)
Replies 10
Whilst I don't disagree the property is called default it would be useful to be able to set these AFTER the SQL connection as been opened / assigned.
Mainly because it would look better if one could size the width of the expression column to accommodate the widest table.field plus the down arrow/elipsis rather than having to adjust this size manually all of the time seems a bit of a shame
I also tried double clicking on the separator line like you do in excel to auto size a column which would also be a nice feature
I have implemented column auto-size on double click on column splitter, the feature will be included in the next release.
Default column widths are applied every time the new Union Subquery pane are created: when new query are assigned to the SQL property, when new subquery are created in the GUI or when Clear method are called. So if you modify the default column width and want to apply it immediately, you can call Clear and then assign the same query to the SQL property.
Thanks very much for this. It will help the control look even more professional !
I will test when next version is released
Fitting of the column's width by it's content on double clicking on the column splitter is made now.
Thanks for this. It's great it works on the Criteria columns too
There are a couple of caveats
The Aggregate column does not allow for the width of the drop down combo
The Grouping column does not allow for the width of the check box in the heading
As both of these columns have fixed size content I do set them wide enough to begin with but should someone double click on them they go too narrow
I have released v1.26.15 with fixed autosize for Aggregate and Grouping columns.
Could you please test it?
I am trying to install the latest version and after pasting in the key I am getting error code 5 can't delete file. I'm not doing anything different to the previous versions I have installed
Thanks
OK I've now got it installed (extra copy of VS open I had not noticed)
Aggregate and Grouping columns now fixed
However (my fault) I had missed the Sort Type column has the same problem as Aggregate
Sort Type column auto sizing is fixed upstream, the fix will be included in the next release.
Hello,
That's right. This property specifies the default width of expression column. Also it should work before assigning the new SQL text (you will see the difference after the assignment). There is no way to control actual columns width of the Query Columns Grid.