ActiveQueryBuilder.View.WinForms 3.2.0.1029

.NET Framework This package is compatible with all versions of .NET Framework.
There is a newer version of this package available.
See the version list below for details. 
dotnet add package ActiveQueryBuilder.View.WinForms --version 3.2.0.1029                

                    
                

            
NuGet\Install-Package ActiveQueryBuilder.View.WinForms -Version 3.2.0.1029
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package. 
<PackageReference Include="ActiveQueryBuilder.View.WinForms" Version="3.2.0.1029" />
For projects that support PackageReference, copy this XML node into the project file to reference the package. 
paket add ActiveQueryBuilder.View.WinForms --version 3.2.0.1029                

                    
                

            
#r "nuget: ActiveQueryBuilder.View.WinForms, 3.2.0.1029"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package. 
// Install ActiveQueryBuilder.View.WinForms as a Cake Addin
#addin nuget:?package=ActiveQueryBuilder.View.WinForms&version=3.2.0.1029

// Install ActiveQueryBuilder.View.WinForms as a Cake Tool
#tool nuget:?package=ActiveQueryBuilder.View.WinForms&version=3.2.0.1029

Visual SQL Query Builder for WinForms that lets users build ad-hoc SQL queries with sub-queries. Active Query Builder has full support of all popular database servers and appropriate SQL dialects. The end-user can combine visual query building with direct SQL query text editing. SQL text editor with code completion and syntax highlighting satisfies the needs of professional query writers.

Product Compatible and additional computed target framework versions.
.NET Framework net is compatible. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
3.12.1.2257 101 11/11/2024
3.12.0.2256 94 10/24/2024
3.11.6.2255 145 9/7/2024
3.11.5.2254 107 8/26/2024
3.11.4.2253 137 7/7/2024
3.11.3.2252 165 4/22/2024
3.11.2.2251 145 3/23/2024
3.11.1.2250 129 3/22/2024
3.11.0.2249 147 3/13/2024
3.10.0.2248 272 12/14/2023
3.9.14.2246 128 12/13/2023
3.9.13.2245 238 9/11/2023
3.9.12.2244 214 5/31/2023
3.9.11.2243 200 5/15/2023
3.9.10.2242 212 4/26/2023
3.9.9.2241 272 4/13/2023
3.9.8.2240 276 3/10/2023
3.9.7.2239 272 2/18/2023
3.9.6.2238 367 1/4/2023
3.9.5.2237 451 10/24/2022
3.9.4.2236 477 9/20/2022
3.9.3.2235 458 9/10/2022
3.9.2.2234 487 8/29/2022
3.9.1.2233 474 8/21/2022
3.9.0.2232 579 7/15/2022
3.8.30.2231 466 7/15/2022
3.8.29.2230 498 7/5/2022
3.8.28.2229 496 7/1/2022
3.8.27.2228 460 6/28/2022
3.8.26.2227 478 6/17/2022
3.8.25.2226 490 6/2/2022
3.8.24.2225 556 5/13/2022
3.8.23.2224 476 5/6/2022
3.8.22.2223 543 4/28/2022
3.8.20.2222 501 4/22/2022
3.8.19.2221 501 4/21/2022
3.8.17.2219 519 2/16/2022
3.8.16.2218 499 1/26/2022
3.8.15.2217 325 1/13/2022
3.8.15.2216 329 1/13/2022
3.8.14.2212 407 12/9/2021
3.8.13.2211 372 12/8/2021
3.8.12.2210 406 11/10/2021
3.8.11.2209 431 11/1/2021
3.8.10.2208 492 9/22/2021
3.8.9.2207 465 8/31/2021
3.8.8.2206 452 8/13/2021
3.8.7.2205 485 7/20/2021
3.8.6.2204 467 7/12/2021
3.8.5.2202 447 6/23/2021
3.8.5.2201 503 6/23/2021
3.8.4.2200 481 6/21/2021
3.8.3.2198 493 6/12/2021
3.8.2.1198 501 5/27/2021
3.8.1.1197 422 5/20/2021
3.8.1.1196 470 5/20/2021
3.8.0.1195 470 5/19/2021
3.7.18.1193 497 3/26/2021
3.7.17.1192 456 3/18/2021
3.7.16.1191 473 3/10/2021
3.7.15.1190 479 3/3/2021
3.7.14.1189 484 2/15/2021
3.7.13.1188 492 2/2/2021
3.7.12.1187 489 1/29/2021
3.7.11.1186 519 1/20/2021
3.7.10.1185 496 1/13/2021
3.7.9.1184 816 1/2/2021
3.7.8.1183 543 12/30/2020
3.7.7.1182 545 12/14/2020
3.7.6.1181 542 11/26/2020
3.7.5.1179 606 10/28/2020
3.7.4.1178 595 10/22/2020
3.7.2.1175 603 9/8/2020
3.7.1.1174 632 8/28/2020
3.7.0.1173 608 8/27/2020
3.6.15.1172 595 8/21/2020
3.6.14.1171 667 8/11/2020
3.6.13.1170 708 8/6/2020
3.6.12.1169 653 8/5/2020
3.6.11.1168 601 8/4/2020
3.6.10.1167 663 7/27/2020
3.6.9.1166 661 7/12/2020
3.6.7.1165 595 7/2/2020
3.6.6.1164 637 6/26/2020
3.6.5.1163 609 6/10/2020
3.6.3.1162 629 6/1/2020
3.6.2.1161 676 5/15/2020
3.6.1.1160 694 5/8/2020
3.6.0.1159 671 4/5/2020
3.5.40.1158 640 3/20/2020
3.5.39.1157 693 3/8/2020
3.5.38.1156 753 2/28/2020
3.5.37.1155 684 2/14/2020
3.5.35.1153 739 1/13/2020
3.5.34.1152 716 12/31/2019
3.5.34.1151 743 12/30/2019
3.5.33.1150 679 12/10/2019
3.5.32.1149 703 11/22/2019
3.5.31.1148 699 11/22/2019
3.5.30.1147 694 11/11/2019
3.5.29.1146 701 11/1/2019
3.5.28.1145 681 10/29/2019
3.5.27.1144 696 10/22/2019
3.5.26.1143 715 10/11/2019
3.5.25.1142 716 10/1/2019
3.5.25.1141 692 9/25/2019
3.5.25.1140 762 8/21/2019
3.5.24.1138 757 8/2/2019
3.5.22.1136 845 7/11/2019
3.5.21.1135 719 6/27/2019
3.5.21.1134 732 6/26/2019
3.5.20.1133 820 6/2/2019
3.5.19.1132 778 5/28/2019
3.5.19.1131 753 5/27/2019
3.5.18.1130 753 5/24/2019
3.5.17.1129 776 5/23/2019
3.5.16.1128 754 5/13/2019
3.5.15.1127 756 4/30/2019
3.5.14.1126 768 4/12/2019
3.5.13.1125 761 3/12/2019
3.5.13.1124 788 3/8/2019
3.5.12.1123 838 2/22/2019
3.5.12.1122 862 2/14/2019
3.5.12.1120 844 2/6/2019
3.5.12.1119 854 2/5/2019
3.5.8.1115 951 12/18/2018
3.5.6.1113 922 11/29/2018
3.5.6.1112 898 11/26/2018
3.5.5.1110 912 11/1/2018
3.5.4.1109 927 10/19/2018
3.5.4.1108 978 10/17/2018
3.5.3.1106 1,030 9/19/2018
3.5.2.1105 1,003 9/12/2018
3.5.1.1104 1,042 9/3/2018
3.5.0.1103 1,056 8/20/2018
3.4.21.1102 989 8/17/2018
3.4.20.1101 1,125 7/13/2018
3.4.19.1100 1,153 7/4/2018
3.4.19.1099 1,096 6/29/2018
3.4.18.1097 1,101 6/21/2018
3.4.16.1093 1,160 5/28/2018
3.4.13.1090 1,128 5/8/2018
3.4.12.1089 1,105 5/7/2018
3.4.11.1088 1,176 4/23/2018
3.4.8.1085 1,202 4/2/2018
3.4.7.1084 1,173 3/7/2018
3.4.6.1083 1,165 3/3/2018
3.4.5.1082 1,052 2/19/2018
3.4.3.1078 1,192 1/26/2018
3.3.25.1073 1,116 12/14/2017
3.3.24.1071 1,091 11/27/2017
3.3.20.1066 1,126 9/22/2017
3.3.16.1063 1,130 8/14/2017
3.3.12.1060 1,173 7/10/2017
3.3.11.1059 1,106 6/28/2017
3.3.10.1057 1,158 6/19/2017
3.3.9.1056 1,170 6/13/2017
3.3.8.1055 1,125 6/5/2017
3.3.7.1054 1,106 6/5/2017
3.3.6.1053 1,156 4/28/2017
3.3.6.1042 1,130 4/26/2017
3.3.3.1039 1,143 3/23/2017
3.3.2.1038 1,141 3/17/2017
3.3.0.1036 1,249 2/27/2017
3.2.2.1035 1,216 1/30/2017
3.2.1.1033 1,188 12/22/2016
3.2.1.1032 1,234 12/9/2016
3.2.1.1031 1,161 11/25/2016
3.2.0.1030 1,183 10/31/2016
3.2.0.1029 1,167 10/27/2016
3.1.1.1028 1,210 9/7/2016
3.1.1.1025 1,166 8/18/2016
3.1.1.1024 1,233 8/8/2016
3.1.1.1022 1,529 7/26/2016
3.1.1.1020 1,218 6/23/2016
3.1.0.1018 1,259 5/12/2016
3.1.0.1017 1,201 5/11/2016
3.1.0.1014 1,252 5/5/2016

+ The QueryBuilder control has got the new controls as dockable panels located to the left or right of the Design Pane.
+ The new the Sub-query Navigation Bar has been made. It was formerly available as a pop-up window of the Query Navigation Bar. (Available as a separate control in the Professional subscriptions only)
+ Usability of the Sub-query Navigation Bar is improved: now you can change the order of union sub-queries using drag'n'drop.
+ The new Properties Bar allows you to set various query, datasource and link properties without the need to open a dialog window. (Available as a separate control in the Professional subscriptions only)
+ The new Dock Manager control has been added. (Available in the Professional subscriptions only)
+ The new properties have been added to the QueryBuilder.PanesConfigurationOptions: SubQueryNavBarEnabled, PropertiesBarEnabled, SubQueryNavBarDockOptions, PropertiesBarDockOptions. The two latter property groups determine the initial state of appropriate sidebar panels and contain the following properties: AutoHide (True/False), Position (Left/Right).
+ The new property QueryBuilder.DockPanelsLayoutXML has been made to save the layout of sidebar panels between work sessions.
+ The new properties have been added to the QueryBuilder.VisualOptions to define colors and font of sidebar panels and its docking system.
= The Query, Datasource, and Link Properties dialogs are redesigned.
+ Query Transformer is now capable of renaming output query columns.
+ The new QueryTransformer.RenameDuplicatedColumns property prescribes to explicitly specify all the columns in the query SELECT list by expanding the asterisk items, then find and rename the unnamed and duplicated column names (default = false).
+ The new QueryTransformer.AlwaysExpandColumnsInQuery instructs to perform asterisk expansion in the query SELECT list even if it's not needed for the specified query transformations (default = false).
! The OutputColumn.Name property has been renamed to OriginalName.
+ The new OutputColumn.PreassignedName allows specifying the needed name for a query output column.
+ The new OutputColumn.ResultName gets the result query columns name, which turned out as a result of automatic columns renaming routine and manual appliance of the new name specified via the PreassignedName property.
+ Localization in the separate controls mode has been fixed.
= The QueryBuilder.Language and QueryView.Language properties are reflections for the global ActiveQueryBuilder.Core.Helpers.Localizer.Language property.
= Batch query column items processing on grouping on/off has been made.
- QueryTransformer: The bug with incorrect ORDER BY generation if column alias is the same as field name has been fixed.
= QueryTransformer: The new SQLGenerationOptions property has been added, the SQLBuilder property has been removed.
= The InvalidOperationException is thrown now if both MetadataItem.MetadataName and MetadataItem.MetadataObject properties are specified.
- The bug on resizing QueryColumnList control if cell editor is active has been fixed.
- The bug with not displaying fields from derived tables in the Expression Editor's tree has been fixed.
+ PostgreSQL: Support of custom aggregate functions has been made.
- MS SQL Server: CHAR and NCHAR, ROW and ROWS are added to the list of valid identifiers.
- Firebird: The simple form of the TRIM function is supported now.
- Oracle: Special form of the TRIM function is supported now.
- Localization in the separate controls mode has been fixed.