sql - ComponentOne Query

Description: applications, without the need for your end-users to learn new skills. It comes complete with a powerful query generation engine, Query engine and schema designer. Features include: SQL database support, Simple ... imaginable queries in advance to working with a rigid user interface. Those problems no longer exist because ComponentOne Query: Collects end-user input and generates an SQL query or an ADO Filter condition ... can still benefit from the powerful Query Engine! The ComponentOne Query object model allows you to programmatically set the fields and conditions specified by your users and generates the SQL statement ...

Screenshots: Handle SQL like errors from within your database application 0 ...

Screenshots: Generate SQL Queries from your data. Use the item selector to select the fields you need and apply the query to see results of show SQL 0 ...

Features: Features: Ad hoc query functionality at run time, not design time-ComponentOne Query collects end-user input and generates an SQL query or an ADO Filter condition at run time. Now you can add ad hoc ... the additional data necessary to generate SQL queries, such as joins and relationships between tables. The Schema Designer can import database structure from any OLE DB data source and create a complete schema ... for you, which can then be customized. You can also create a schema manually, without connecting to a database SQL database support- SQL queries generated by ComponentOne Query can run in every database ...

Compatibility: Microsoft Transaction Server Compatible (MTS) Compatible Containers Microsoft Visual Studio 6.0 Microsoft Visual Basic 6.0 Microsoft Visual C++ 6.0 Microsoft SQL Server 2005 Microsoft SQL Server 2000 ... Microsoft SQL Server 7.0 Microsoft Internet Explorer 5.0 Microsoft Internet Explorer 4.0 Delphi 5.0 Delphi 4.0 Product Class Business Components Test and Review Status Installation Tested- Yes Uninstall ...

Support: ComponentOne Platinum Support Subscriptions provide a full year of Telephone and Online Technical Support. ComponentOne Technical Support Engineers are available by phone Monday through Friday, except U.S. holidays, from 9:00 a.m. to 5:00 p.m. Eastern,USA. Customers outside the USA, please remember ...

Licensing: ...

Pricing: ...

Screenshots: Build you own Custom User Interfaces(UI) to interact with your data 0 ...

Screenshots: Apply (DAO) Data Access Objects in your projects 0 ...

Screenshots: Alias columns/fields and other items when returning your query results 0 ...

Screenshots: Calculate Fields while applying varying formats 0 ...

Customer Review: Overall a great tool for giving the querying power back to the user (without having to write a squillion queries). Of course DBA's will all scream because the user can do some stupid things... but hey, they pay the bills right? Schema designer included is good (but has a few bugs, which you ...