Active Query Builder support area

ActiveX properties i'm not quite sure about

Andrew Kennard

9 years ago
updated 8 years ago
Completed

I've been through the properties and used the google search on your site to try and find some help on what they do

I've managed to find something about most of them but these few either don't seem to work or I can't find any info on them. Maybe some are obsolete

None of these appear to me to do what their names suggest

TableChecksCountInCaption // I assume this was the number of fields ticked shown in the title bar ? doesn't seem to appear there ?

ColumnPaneSplitterHeight // I thought this would change the height of the grab handle but it does not seem to

TreePaneSplitterWidth // Similar to above

ObjectsTreeWidth // This might be working but when I set it to a big value I though there might be a horizontal scroll bar

ColumnWidthExpression // I thought this would effect the express column in the columns grid at the bottom of the control

/SQLSyntaxParams // doesn't seem to be any help on what these might be

MetadataXmlFile // again not much help found on this

SQLSyntax // I can see setting this to auto and getting another property to find out the type of DB connected to bu not what happens if you set this to one of its valid values

Thanks in advnace as always

Replies 4

Newest first
Newest first Oldest first

Sergey Kraikov

9 years ago

Could you please describe in details the Metadata Tree width issue?

Reply Link

Setting ObjectsTreeWIdth to 400 i'm not seeing any difference, but i';m not 100% sure on what I should be seeing ?

Also thanks very much for all the addiotional code comments that are now coming from the control, I notice ObjectsTreeWIdth is marked as obsolete ?

I've added the Max constraint to the ObjectsTreeWidth, now the maximum width of the tree is 500 px

I also added the Min constraint for the Design Pane. These should fix ObjectsTreeWidth issue.

The fixes are included in the v1.26.12

That's right. When TableChecksCountInCaption is True, every datasource on Design Pane displays the number of checked fields, for example "(4) Orders"

ColumnPaneSplitterHeight // I thought this would change the height of the grab handle but it does not seem to
TreePaneSplitterWidth // Similar to above

Our component supports different GUI toolkits (at the build time), and these props works for some of them but do nothing for the splitters used by default.

I'll check it

Obsolete, use SelectList.DefExpressionColumnWidth instead

Some syntaxes have additional customizable params. When you set SQLSyntax, you can read SQLSyntaxParams and get INI-like list

if you prepare a preloaded metadata XML file, you can specify it and it will be loaded on control initialization

SQLSyntax // I can see setting this to auto and getting another property to find out the type of DB connected to but not what happens if you set this to one of its valid values

When you use Auto, Query Builder performs server detection after Connect. This auto detection can introduce additional delay, and to avoid it you can specify used server directly using one of the values from the TaxqbSyntax enum.