Active Query Builder is a component for business applications which helps users without any SQL experience to work with SQL queries and get data fast. Users can get a clear view of database schema and design SQL queries with natural point-and-click actions rather than tedious typing. Active Query Builder assists novice users learning SQL and allows experienced users to analyze and understand their queries better by parsing them and building the visual diagram. With…
$199
per developer
ComponentOne
Score 9.0 out of 10
N/A
ComponentOne Studio, from software company GrapeCity in Pittsburgh, Pennsylvania, provides Visual Studio controls.
This is a good framework to use if your project requires frequent database queries. The product is made for both complete amateurs and seasoned experts. Prompt, courteous, and expert assistance; any problems are addressed and fixed without delay. Relatively inexpensive Inadequate, if there are new people involved, delays due to a lack of documentation are likely, and issues with code completion may arise.
C1 is great for creating custom reports. We have client apps where we've created some fairly complicated reports such as invoices and real estate inspections. We also use the True DBGrid in many of our apps since it is so customizable. Its grouping and filtering features are very nice and can provide summary counts and totals at the bottom or right side of the grid that are very handy.
The True DBGrid control is nice for showing parent/child relationships and being able to drill down and show the child data. It also is nice for showing summary totals.
The report engine is great for building custom reports for Win Forms or web apps. It can do everything that Crystal Reports can do.
They have a good selection of controls that can do just about anything you can imagine.
I have used Flutter to begin and with flutter you need learn a language called Dart which is not needed with AQB, which is the main reason for us to pick Active Query Builder as a choice over Flutter. AQB supports all the merchant SQL databases with native syntax support, query optimizations and more
We have been in business since 1992, so we have used many different products over the years. The two other products we've primary used that are similar to ComponentOne, are Infragistics and Crystal Reports. Infragistics has a vast array of controls similar to ComponentOne. We use both to be honest and I'm not sure which one I would pick over the other. I guess that would depend on what you're trying to accomplish and if one had some control or capability that the other didn't. ComponentOne does have the reporting capabilities, where Infragistics does not.
ComponentOne allows us to add additional features to our apps that wouldn't be found in apps written with just Visual Studio itself. That allows our clients to get more creative in their requirements, which in turn, means more work and billable hours for us!
Our apps appear more professional when using ComponentOne which helps us get projects for new clients.
ComponentOne also helps us to save clients some money since we are not having to develop things that it can do from scratch.