HomeActive Query BuilderExtend a existing Where-Clause programatically

Extend a existing Where-Clause programatically


Hi,

i have a problem with extending a where-clause.

Ok, say i hava a sql-statement e.g. "select * from table where deleted = 0 and visible = 1 order by date"

Now i want to add a user-defined filter(e.g. "firstname = 'abc' and (lastname = 'def' or lastname = 'ghi')" ) to the existing where-clause.

The main sql-statement is already parsed by TacQueryBuilder.
The user-defined filter is parsed to a TSQLExpressionItem by TacQueryBuilder.SQLContext.ParseLogicalExpression.

How can i combine them or is it completele wrong what i do?

Greetings
Uli Korn | email
November 4 2010, 07:40 AM
Dear Uli,

Sorry for the late response. Please use support requests for faster responses.

I recommend you to use the way that presented in the Query Modification demo project.
Sergey Smagin | email
4 days since original post
This topic is closed