HomeActive Query BuilderEditing column text of the CriteriaList and applying it to The SQL-Query

Editing column text of the CriteriaList and applying it to The SQL-Query


Hi,

it is possible to read-out and edit a singe cell of the CriteriaList? I want to change the content of the "Criteria"-column in a CriteriaItem and apply the change to the SQL query. To the CriteriaItems I have a ContextMenu already. There I want to choose a variable name to insert it to the cell, but I didn't find a way to get access to this cell.

Can anyone help me?

Thank You.
Marcus Lewerenz | email
July 2 2012, 04:32 AM
Dear Markus,

This article contains code sample of the ValidateContexMenu and MenuItem_click handlers: http://www.activedbsoft.com/helpdesk/index.php?pg=kb.page&id=12

There's a list of possible combinations of Control and ControlOwner parameters. In case of working with the CriteriaList, you should expect the CriteriaListControl and CriteriaItem objects pair. To modify the query, use the CriteriaItem object: It has the ConditionStrings collection that holds values of Criteria/Or cells.

Should you have any further questions, please do not hesitate to ask.
Sergey Smagin | email
4 days, 10 hours since original post
Hi,

okay thanks - now it works. I didn't realized, that the ConditionStrings are the Content of the CriteriaCell.
Marcus Lewerenz | email
3 weeks, 1 day since original post
This topic is closed