LLBlgen 4.0 Sql Server 2008 C# Windows Application LLBLgen runtime framework.

Dear Team,

How can I set CasesensitiveCollation=true for the "description" in the following code ?

public static DataTable TitleView1(string description)
        {
            Filter.Clear();
            _sort = null;
            var titleview = new TitleViewTypedList();
            Filter.Add(new FieldCompareValuePredicate(TitleFields.Flag.SetObjectAlias("T"), ComparisonOperator.Equal,
                                                      PublicConstantClass.Validflag));
            Filter.AddWithAnd(new FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"),
                                                     ChangeCaseClass.Cleanstring("%" + description + "%")));
            _sort =
                new SortExpression(TitleFields.Description.SetObjectAlias("T") | SortOperator.Ascending);
            titleview.Fill(0, _sort, true, Filter);
            return titleview;
        }

by first creating a variable which you give as value: FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"), ChangeCaseClass.Cleanstring("%" + description + "%"))

and then set the flag on the variable?

Otis wrote:

by first creating a variable which you give as value: FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"), ChangeCaseClass.Cleanstring("%" + description + "%"))

and then set the flag on the variable?

I can interchange the lines.

I'm sorry, but I don't think I understand what you meant with your last post?

Otis wrote:

I'm sorry, but I don't think I understand what you meant with your last post?

I mean in interchanged statements as below

public static DataTable TitleView1(string description)
        {
            Filter.Clear();
            _sort = null;
            var titleview = new TitleViewTypedList();
            Filter.Add(new FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"),
                                                     ChangeCaseClass.Cleanstring("%" + description + "%")));
            Filter.AddWithAnd(new FieldCompareValuePredicate(TitleFields.Flag.SetObjectAlias("T"), ComparisonOperator.Equal,
                                                      PublicConstantClass.Validflag));
            _sort =
                new SortExpression(TitleFields.Description.SetObjectAlias("T") | SortOperator.Ascending);
            titleview.Fill(0, _sort, true, Filter);
            return titleview;
        }

Now I need to set CaseSensitiveCollation=true for the field title.description

public static DataTable TitleView1(string description)
        {
            var likePredicate = new FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"),
                                                     ChangeCaseClass.Cleanstring("%" + description.ToUpper() + "%"))

            likePredicate.CaseSensitiveCollation = true;

            Filter.Clear();
            _sort = null;
            var titleview = new TitleViewTypedList();
            Filter.Add();
            Filter.AddWithAnd(new FieldCompareValuePredicate(TitleFields.Flag.SetObjectAlias("T"), ComparisonOperator.Equal,
                                                     PublicConstantClass.Validflag));
            _sort =
                new SortExpression(TitleFields.Description.SetObjectAlias("T") | SortOperator.Ascending);
            titleview.Fill(0, _sort, true, Filter);
            return titleview;
        }

Walaa wrote:

public static DataTable TitleView1(string description)
        {
            var likePredicate = new FieldLikePredicate(TitleFields.Description.SetObjectAlias("T"),
                                                     ChangeCaseClass.Cleanstring("%" + description.ToUpper() + "%"))

            likePredicate.CaseSensitiveCollation = true;

            Filter.Clear();
            _sort = null;
            var titleview = new TitleViewTypedList();
            Filter.Add();
            Filter.AddWithAnd(new FieldCompareValuePredicate(TitleFields.Flag.SetObjectAlias("T"), ComparisonOperator.Equal,
                                                     PublicConstantClass.Validflag));
            _sort =
                new SortExpression(TitleFields.Description.SetObjectAlias("T") | SortOperator.Ascending);
            titleview.Fill(0, _sort, true, Filter);
            return titleview;
        }

Thank You Sir!