473,724 Members | 2,290 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Visual Query Builder with unions and sub-queries

I am glad to present to the community of this group the new version of
our component intended for visual building of SQL queries via an
intuitive interface - Active Query Builder
(http://www.activequerybuilder.com/). It has full support for MS SQL
Server dialect starting from version 7 to 2005.

Active Query Builder can be used in different development environments.
Today our visual component is availiable in the following editions:
ActiveX Edition (.Net-ready COM/ActiveX control) and VCL Edition
(Borland Delphi and C++ Builder component).

It differs from the rest of the components by its the powerful
graphical engine that allows you to build queries visually involving
unions, nested joins and sub-queries. Working with Active SQL Query
builder you can access each union and subquery in one-touch; complex
queries can be navigated easily with the tree pane. Columns pane allows
you to define grouping, sorting, and constructing criteria in a simple
and direct way.

The interface of Active SQL Query Builder for Delphi is similar to
either MS-Access or SQL Server visual query construction interface, but
is much more powerful compared to other similar components. The
component may be integrated into your application written in almost any
language with just few lines of code. Active Query Builder is shipped
with detailed help system and easy-to-understand demo application to
help you minimize the learning curve.

You can download the Free edition of our component as well as compiled
demo application from the download page at

Thank you for your attention.

Merry Christmas!

Dec 27 '05 #1
0 1996

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Chris | last post by:
I am just beginning programming again and need a bit of advice. I have both Visual C++ 6.0 Standard Edition and Borland C++ Builder 6. Of these two which do you consider the best for programming windows programs (not the DOS style program). I have had a quick look at both of these and Borland seems to have a lot more components (Buttons, Forms etc) than Microsoft Visual C++. Does Visual C++ have these components easily accesable. Chris.
by: NAJH | last post by:
I've been trying to do a union with a subquery - I've made a different example which follows the same principles as follows: First bit brings back accounts which are in the top 10 to 15 by account name. Second bit brings back accounts which are in the bottom 10 to 15 by account name. I want to union the two result sets together. These selects work as
by: Neil Zanella | last post by:
Hello, I would like to know whether the following C fragment is legal in standard C and behaves as intended under conforming implementations... union foo { char c; double d; };
by: Bob | last post by:
Trying to use VBisual web developer express 2005 beta 2. Dragged an accessdatasource to the blank web page. Started to configure. Entered location of an access database. On next page, clicked on Query builder. Got error with "Microsoft Visual Studio" in the title - I am using VWD express 2005 beta 2 although I also have Visual Studio 2003 installed. the text of the error is: Retrieving the com class factory for component w/ clsid...
by: teddysnips | last post by:
I have to write an application to do some data cleansing. It's a Contact database, but over a number of years there are multiple companies which are all essentially the same entity. For each company there are also multiple contacts, some of which may be congruent. It's a very simple app. with only two forms. The first form shows two lists. The left-hand list is a Single-Select showing all the companies. The user chooses one company -...
by: Farshid | last post by:
Hi Is there any way to use Visual Studio Query Builder in Windows Forms applications. I think query builder dialog is in Micosoft.VSDesigner assembly but i dont know how to use it. Thank You for your help
by: EJO | last post by:
In the query builder, I can create a query that will take a date/time as criteria, and the query finds the records: SELECT SRSrvcsEquip.Stock, SRSrvcsEquip.Activity, SRSrvcsEquip.EquipOwned, SRSrvcsEquip.Manufacturer, SRSrvcsEquip.EHSN, SRSrvcsEquip.Qty, SRSrvcsEquip.PartNumber, SRSrvcsEquip.Description, SRSrvcsEquip.ListType, SRSrvcsEquip.Site_ID, SRSrvcsEquip.SR_ID, SRSrvcsEquip.ListDate, SRSrvcsEquip.ID FROM SRSrvcsEquip WHERE...
by: FrozenDude | last post by:
Does anyone know of or have a favourite 3rd party Visual Query Builder? We are looking for a very easy to use interface that provides SQL code verification, table joins etc. Thanks, Dave
by: Vaudousi | last post by:
Hi All Asking help again. I am a casual user of Access. I have a simple application which works correctly under Access 2003. I tried it under 2007. One of the module refuses to work. I have : A table : PersonId, Name, Birthday ---- A form (frmBirthDay) which includes ActiveX MonthView (ctlCalendar) and a subform (frmBirthDaySub) which displays names and year of birth
by: iheartvba | last post by:
Hi I am getting the following error when i click cmdFFR (See note1): Invalid SQL statement, expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE'. I can't figure out why this is. Spelling all seems to be correct. Public Dimensions are as follow: Option Compare Database Option Explicit Public cnn As ADODB.Connection Public rst As New ADODB.Recordset (Note1) Private Sub cmdFFR_Click()
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.