How to set conditions in IBCquery editor

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Dokkie
Posts: 43
Joined: Wed 08 Oct 2008 21:58

How to set conditions in IBCquery editor

Post by Dokkie » Sun 26 Oct 2014 02:48

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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How to set conditions in IBCquery editor

Post by AlexP » Mon 27 Oct 2014 09:28

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.

Dokkie
Posts: 43
Joined: Wed 08 Oct 2008 21:58

Re: How to set conditions in IBCquery editor

Post by Dokkie » Mon 27 Oct 2014 13:21

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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: How to set conditions in IBCquery editor

Post by AlexP » Wed 29 Oct 2014 06:57

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.

Post Reply