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 82 11/11/2024
3.12.0.2256 90 10/24/2024
3.11.6.2255 142 9/7/2024
3.11.5.2254 105 8/26/2024
3.11.4.2253 135 7/7/2024
3.11.3.2252 163 4/22/2024
3.11.2.2251 142 3/23/2024
3.11.1.2250 127 3/22/2024
3.11.0.2249 144 3/13/2024
3.10.0.2248 270 12/14/2023
3.9.14.2246 124 12/13/2023
3.9.13.2245 235 9/11/2023
3.9.12.2244 212 5/31/2023
3.9.11.2243 198 5/15/2023
3.9.10.2242 210 4/26/2023
3.9.9.2241 270 4/13/2023
3.9.8.2240 274 3/10/2023
3.9.7.2239 270 2/18/2023
3.9.6.2238 365 1/4/2023
3.9.5.2237 447 10/24/2022
3.9.4.2236 475 9/20/2022
3.9.3.2235 456 9/10/2022
3.9.2.2234 483 8/29/2022
3.9.1.2233 472 8/21/2022
3.9.0.2232 577 7/15/2022
3.8.30.2231 462 7/15/2022
3.8.29.2230 496 7/5/2022
3.8.28.2229 494 7/1/2022
3.8.27.2228 458 6/28/2022
3.8.26.2227 476 6/17/2022
3.8.25.2226 488 6/2/2022
3.8.24.2225 554 5/13/2022
3.8.23.2224 474 5/6/2022
3.8.22.2223 541 4/28/2022
3.8.20.2222 499 4/22/2022
3.8.19.2221 499 4/21/2022
3.8.17.2219 517 2/16/2022
3.8.16.2218 497 1/26/2022
3.8.15.2217 323 1/13/2022
3.8.15.2216 327 1/13/2022
3.8.14.2212 405 12/9/2021
3.8.13.2211 370 12/8/2021
3.8.12.2210 404 11/10/2021
3.8.11.2209 429 11/1/2021
3.8.10.2208 490 9/22/2021
3.8.9.2207 463 8/31/2021
3.8.8.2206 450 8/13/2021
3.8.7.2205 483 7/20/2021
3.8.6.2204 465 7/12/2021
3.8.5.2202 445 6/23/2021
3.8.5.2201 501 6/23/2021
3.8.4.2200 479 6/21/2021
3.8.3.2198 491 6/12/2021
3.8.2.1198 499 5/27/2021
3.8.1.1197 420 5/20/2021
3.8.1.1196 468 5/20/2021
3.8.0.1195 468 5/19/2021
3.7.18.1193 495 3/26/2021
3.7.17.1192 454 3/18/2021
3.7.16.1191 471 3/10/2021
3.7.15.1190 477 3/3/2021
3.7.14.1189 482 2/15/2021
3.7.13.1188 490 2/2/2021
3.7.12.1187 487 1/29/2021
3.7.11.1186 517 1/20/2021
3.7.10.1185 494 1/13/2021
3.7.9.1184 814 1/2/2021
3.7.8.1183 541 12/30/2020
3.7.7.1182 543 12/14/2020
3.7.6.1181 540 11/26/2020
3.7.5.1179 604 10/28/2020
3.7.4.1178 593 10/22/2020
3.7.2.1175 601 9/8/2020
3.7.1.1174 630 8/28/2020
3.7.0.1173 606 8/27/2020
3.6.15.1172 593 8/21/2020
3.6.14.1171 665 8/11/2020
3.6.13.1170 706 8/6/2020
3.6.12.1169 651 8/5/2020
3.6.11.1168 599 8/4/2020
3.6.10.1167 661 7/27/2020
3.6.9.1166 659 7/12/2020
3.6.7.1165 593 7/2/2020
3.6.6.1164 635 6/26/2020
3.6.5.1163 607 6/10/2020
3.6.3.1162 627 6/1/2020
3.6.2.1161 674 5/15/2020
3.6.1.1160 692 5/8/2020
3.6.0.1159 669 4/5/2020
3.5.40.1158 638 3/20/2020
3.5.39.1157 691 3/8/2020
3.5.38.1156 751 2/28/2020
3.5.37.1155 682 2/14/2020
3.5.35.1153 737 1/13/2020
3.5.34.1152 714 12/31/2019
3.5.34.1151 741 12/30/2019
3.5.33.1150 677 12/10/2019
3.5.32.1149 701 11/22/2019
3.5.31.1148 697 11/22/2019
3.5.30.1147 692 11/11/2019
3.5.29.1146 699 11/1/2019
3.5.28.1145 679 10/29/2019
3.5.27.1144 694 10/22/2019
3.5.26.1143 713 10/11/2019
3.5.25.1142 714 10/1/2019
3.5.25.1141 690 9/25/2019
3.5.25.1140 760 8/21/2019
3.5.24.1138 755 8/2/2019
3.5.22.1136 843 7/11/2019
3.5.21.1135 717 6/27/2019
3.5.21.1134 730 6/26/2019
3.5.20.1133 818 6/2/2019
3.5.19.1132 776 5/28/2019
3.5.19.1131 751 5/27/2019
3.5.18.1130 751 5/24/2019
3.5.17.1129 774 5/23/2019
3.5.16.1128 752 5/13/2019
3.5.15.1127 754 4/30/2019
3.5.14.1126 766 4/12/2019
3.5.13.1125 759 3/12/2019
3.5.13.1124 786 3/8/2019
3.5.12.1123 836 2/22/2019
3.5.12.1122 860 2/14/2019
3.5.12.1120 842 2/6/2019
3.5.12.1119 852 2/5/2019
3.5.8.1115 949 12/18/2018
3.5.6.1113 920 11/29/2018
3.5.6.1112 896 11/26/2018
3.5.5.1110 910 11/1/2018
3.5.4.1109 925 10/19/2018
3.5.4.1108 976 10/17/2018
3.5.3.1106 1,028 9/19/2018
3.5.2.1105 1,001 9/12/2018
3.5.1.1104 1,040 9/3/2018
3.5.0.1103 1,054 8/20/2018
3.4.21.1102 987 8/17/2018
3.4.20.1101 1,123 7/13/2018
3.4.19.1100 1,151 7/4/2018
3.4.19.1099 1,094 6/29/2018
3.4.18.1097 1,099 6/21/2018
3.4.16.1093 1,156 5/28/2018
3.4.13.1090 1,126 5/8/2018
3.4.12.1089 1,103 5/7/2018
3.4.11.1088 1,174 4/23/2018
3.4.8.1085 1,200 4/2/2018
3.4.7.1084 1,171 3/7/2018
3.4.6.1083 1,163 3/3/2018
3.4.5.1082 1,050 2/19/2018
3.4.3.1078 1,188 1/26/2018
3.3.25.1073 1,114 12/14/2017
3.3.24.1071 1,089 11/27/2017
3.3.20.1066 1,124 9/22/2017
3.3.16.1063 1,128 8/14/2017
3.3.12.1060 1,171 7/10/2017
3.3.11.1059 1,104 6/28/2017
3.3.10.1057 1,156 6/19/2017
3.3.9.1056 1,168 6/13/2017
3.3.8.1055 1,123 6/5/2017
3.3.7.1054 1,104 6/5/2017
3.3.6.1053 1,154 4/28/2017
3.3.6.1042 1,128 4/26/2017
3.3.3.1039 1,141 3/23/2017
3.3.2.1038 1,139 3/17/2017
3.3.0.1036 1,247 2/27/2017
3.2.2.1035 1,214 1/30/2017
3.2.1.1033 1,186 12/22/2016
3.2.1.1032 1,232 12/9/2016
3.2.1.1031 1,159 11/25/2016
3.2.0.1030 1,181 10/31/2016
3.2.0.1029 1,165 10/27/2016
3.1.1.1028 1,208 9/7/2016
3.1.1.1025 1,164 8/18/2016
3.1.1.1024 1,231 8/8/2016
3.1.1.1022 1,527 7/26/2016
3.1.1.1020 1,216 6/23/2016
3.1.0.1018 1,257 5/12/2016
3.1.0.1017 1,197 5/11/2016
3.1.0.1014 1,250 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.