Assume that myCombo is the name of your combobox:
In InitializeCustomCode method, add the line:
myCombo.BeforeDropDown += new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);
In the DestroyCustomCode method, add the line:
myCombo.BeforeDropDown -= new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);
Add the following method:
private static void myCombo_BeforeDropDown(object
sender, System.ComponentModel.CancelEventArgs args)
{
EpiCombo combo = (EpiCombo)sender;
DataTable dt =
(DataTable)combo.DataSource;
if (dt.ExtendedProperties["Modified"] !=
null)
return;
dt.ExtendedProperties["Modified"] =
true;
foreach (DataRow row in dt.Rows) {
if
(!(bool)row["IsActive"]) {
combo.Rows.ColumnFilters["CodeID"].FilterConditions.Add(Infragistics.Win\
.UltraWinGrid.FilterComparisionOperator.NotEquals, row["CodeID"]);
}
}
}
In InitializeCustomCode method, add the line:
myCombo.BeforeDropDown += new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);
In the DestroyCustomCode method, add the line:
myCombo.BeforeDropDown -= new
System.ComponentModel.CancelEventHandler(Script.myCombo_BeforeDropDown);
Add the following method:
private static void myCombo_BeforeDropDown(object
sender, System.ComponentModel.CancelEventArgs args)
{
EpiCombo combo = (EpiCombo)sender;
DataTable dt =
(DataTable)combo.DataSource;
if (dt.ExtendedProperties["Modified"] !=
null)
return;
dt.ExtendedProperties["Modified"] =
true;
foreach (DataRow row in dt.Rows) {
if
(!(bool)row["IsActive"]) {
combo.Rows.ColumnFilters["CodeID"].FilterConditions.Add(Infragistics.Win\
.UltraWinGrid.FilterComparisionOperator.NotEquals, row["CodeID"]);
}
}
}
--- In vantage@yahoogroups.com, Joe Rojas <jrojas@...> wrote:
>
> Hello,
>
>
>
> I have an EpiCombo on my screen that is setup to pull a specific user
> code.
>
> We recently modified the code list and I marked some as inactive.
>
> I'd like to now go back and filter the inactive codes from the
EpiCombo
> but I just can't figure it out.
>
> I added UDCodes.IsActive = FALSE to the EpiFiltersAppend property but
it
> keeps telling me that IsActive must be a quoted constant of an
> unambiguous field in query qryUDCodes.
>
>
>
> Any ideas on how I do this?
>
>
>
>
>
>
>
>
>
>
> Joe Rojas | Director of Information Technology | Mats Inc
> dir: 781-573-0291 | cell: 781-408-9278 | fax: 781-232-5191
> jrojas@... | www.matsinc.com Ask us about our clean, green and
beautiful matting and flooring
>
>
> This message is intended only for the individual named. If you are not
the named addressee you should not disseminate, distribute or copy this
e-mail. Please notify the sender immediately by e-mail if you have
received this e-mail by mistake. Please note that any views or opinions
presented in this email are solely those of the author and do not
necessarily represent those of the company.
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]