ActiveX control to build complex SQL queries.
Energetic Query Builder ActiveX Release is a control in order to build complex SQL concerns via an intuitive visible interface just like MS-Access, yet much more powerful in comparison to other similar elements. It allows you in order to define grouping and working, to construct criteria within a simple and immediate way. Each union plus sub-query has its very own working area where this could be built creatively as easy as individual query.
Active Query Constructor is a true dual end query builder, therefore you might combine visual query developing with direct SQL problem editing. The sophisticated Dynamic SQL parser can convert any valid SQL declaration into its visual rendering. SQL Formatter will help you to personalize the SQL code design the way you including it. Capability to retrieve different information about the problem, such as list associated with used tables and areas, enables you to prevent execution associated with unauthorized queries.
Active Problem Builder supports Oracle, Microsof company SQL Server, MS Accessibility, MySQL, PostgreSQL, Informix, Sybase, Interbase, Firebird, and additional SQL dialects.
In several cases, direct connection in order to the database is unwanted as well as impossible from the particular point of view associated with security or performance, by way of example in the ASP. INTERNET environment. In this situation, the most convenient remedy would be to function with Active Query Constructor in offline mode, launching metadata information from the earlier saved XML file. This also makes loading metadata almost instant regardless associated with the amount of objects getting loaded.
The newest version associated with our component enables you to substitute real table and industry names with the user friendly aliases.
Active Query Constructor can be used within any software project which usually supports ActiveX controls simply because well as in the particular. Net projects. For illustration, you can use this with Visual Basic six. 0 and. NET, Visible C 6. 0, Visible C#, PowerBuilder and therefore on. Active Query Constructor was successfully tested within Windows. Forms and OR NET. NET environments, with. INTERNET Framework 1. 1 plus higher.
|
Active Query Builder ActiveX Edition
Downloads
: 229
