Active Query Builder support area

DefExpressionColumnWidth etc have to be set BEFORE the database connection is opened otherwise they have no effect

Avatar
  • updated
  • Completed

As the subject says ! :)

Avatar
Andrey Zavyalov, PM

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.

Avatar
Andrew Kennard

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

Avatar

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.

Avatar
Andrew Kennard

Thanks very much for this. It will help the control look even more professional !

I will test when next version is released

Avatar
Andrey Zavyalov, PM

Fitting of the column's width by it's content on double clicking on the column splitter is made now.

Avatar
Andrew Kennard

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

Avatar

I have released v1.26.15 with fixed autosize for Aggregate and Grouping columns.

Could you please test it?

Avatar
Andrew Kennard

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

Avatar
Andrew Kennard

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

Avatar

Sort Type column auto sizing is fixed upstream, the fix will be included in the next release.