Devart Forums

I'm trying to set a condition in the IBCQuery editor.
Using latest version of IBDAC with Delphi XE2

In the conditions tab I do the following:-
1. Add a Condition Name eg: TaxStatus
2. Add a Value TAXABLE=0
3. Select the condition and check Enabled

The select statement for testing purposes is: Select * from VU_PURCHASERECEIPT

Still in the IBCQuery editor press Execute then open the data editor.
The selected and enabled condition entered above is ignored and all records with TAXABLE column = 0 and = 1 are displayed.

How should this be set up?

Hello,

The Enabled check-box in the Conditions visual editor is responsible for a particular Condition. To enable/disable Conditions for a query, you should use the methods IBCQuery.Conditions.Enable/IBCQuery.Conditions.Disable.

I understand and have used the methods associated with conditions by calling them for a particular query - they work well.

So, the IBquery editor will not show the result of setting and enabling a condition from within the IBquery editor? iow the IBquery editor cannot be used to construct and test a condition while in the editor?

For the time being, IBDAC doesn't support such functionality.We will consider the possibility to change this behavior in one of the next versions.