Active Query Builder support area

Dropbown Box in "Column Name" field

Avatar
Simon
  • updated
  • Completed

Is there a way to have either a dropdown box or a combo box in the "Column Name" field?

I am still evaluating and I am not sure I have full access to setting the "Column Name" at all.

Thank you,

Simon

Replies 15
Avatar
0
Andrey Zavyalov, PM

Have a look at the "Query Columns List - Custom Columns Demo" project. It contains the sample source code.

All demo projects are installed in the Documents folder inside the user's profile directory. Look for them in the "Active Query Builder *** Examples" subfolder.


Avatar
0
Simon

I installed the WPF version, could you please point me in the right direction on how to do this?

Ideally I would want to have a dropdown in the Alias textbox, if not possible I would want to add a column that would serve the same purpose.

TY

Avatar
0
Andrey Zavyalov, PM

Hello, Simon.

This feature is already available in WPF edition. Have a look at the QueryColumnsList - Custom Columns Demo project.

Avatar
0
Simon

In the WinForms Edition you can hide the original "Column name" column and create a new one with a combo box.

Can you do that in the WPF version as well?

Avatar
0
Simon

OK, thank you.

Avatar
0
Andrey Zavyalov, PM

Sorry, it is not possible in the ASP.NET version.

Avatar
0
Simon

What about in the ASP version? That's the one we are using. Thank you.

Avatar
0
Andrey Zavyalov, PM

In the WinForms Edition you can hide the original "Column name" column and create a new one with a combo box.

Avatar
0
Simon

I think I am OK with just the SELECT, we can work around that.

What would really help is a combo in the "Column Name" field. It sounds like that is not possible at the moment. Can you please confirm?

Avatar
0
Andrey Zavyalov, PM

You right, the current version of Active Query Builder doesn't support INSERT statements, but if you use the WinForms edition (I'm still not sure about that), you can create an additional column (if user wants to build an INSERT statement) and turn the SELECT statement into INSERT by getting information from this column.