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?
How to set conditions in IBCquery editor
Re: How to set conditions in IBCquery editor
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.
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.
Re: How to set conditions in IBCquery editor
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?
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?
Re: How to set conditions in IBCquery 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.