HomeActive Query BuilderThere is a problem with the Criteria Pane in the Active Query Builder ActiveX Edition.

There is a problem with the Criteria Pane in the Active Query Builder ActiveX Edition.


When I go to put a criteria lets say on the second expression down, it adds the criteria to the first expression when completing the 'Where' clause.

Ex:
Output Expression Aggregate Alias ... Criteria
------ ---------- --------- ----- --- --------
DeviceName
SerialNumber = 'CAT085KI87'
ModelNumber
DistrictTag



This is the SQL Statement it builds:

Select Devices.deviceName, Identification.SerialNumber,
Identification.ModelNumber, Identification.DistrictTag
From Devices Inner Join
Identification On Devices.identificationID = Identification.identificationID
Where Devices.deviceName = 'CAT085KI87'
Joe Burton | email
May 30 2008, 05:42 PM
I forgot to mention that I'm using the free version of the ActiveX control
Joe Burton | email
3 mins since original post
Dear Joe,

It seems that you use an old version of the component. Please download the latest version from http://www.activequerybuilder.com/download.html

Sincerely
Sergey Smagin
Sergey Smagin | email
1 day, 5 hours since original post
This topic is closed