HomeActive Query BuilderVCL Query Builder & Parameters Bug

VCL Query Builder & Parameters Bug


I am using the VCL Query Builder and am assigning some SQL to a QueryBuilder object (TacQueryBuilder) and am experiencing the following issue:

If i use this SQL everything works:
Select *
From dbo.Test
Where Column1 = :Param

If i use this SQL, the builder fails:
Select *
From dbo.Test
Where Column1 = :Param_ID

The ID parameter is incredibly important, any reason why it would not work?
Leigh Shayler | email
December 20 2010, 07:57 PM
What SQL syntax provider you use and what version of the component you have? We need this information to investigate the problem.
Sergey Smagin | email
7 hours, 14 mins since original post
Hi, this only seems to occur when I use the MSSQL Syntax Provider, I believe I am using the latest version of the VCL query builder but can not find the version number anywhere. I can reproduce the issue with the following steps:

1. Open the ADO Demo project
2. Add a MS SQL Syntax Provider
3. Configure the Query Builder to use the MSSQL Syntax provider
4. Enter the following SQL 'Select :site_id'

When you enter the SQL you will notice that the select statement is parsed as

Field = ':site'
Alias = '_id'

Leigh Shayler | email
1 week, 1 day since original post
The version can be found in the 'version' file in the installation directory. This problem was fixed in version 1.15.21, the latest version is 1.15.24. You may see the full history here: http://www.activequerybuilder.com/history.html?sec=3-2
Sergey Smagin | email
1 week, 1 day since original post
Thanks, it appears I am using an older version (1.15.0)

Where can I access updates to the component?
Leigh Shayler | email
1 week, 3 days since original post
This topic is closed