Hello all,

I work on SQL Server and use LLBL v2.0 adapter, .NET 2.0.50727.

I need to construct a sql statement like that to obtain invoices

AND ([T_FACTURES].[FAC_S_ID] LIKE '%/ AA'
OR [T_FACTURES].[FAC_S_ID] LIKE '%/ DA' 
OR [T_FACTURES].[FAC_S_ID] LIKE '%/ AV')

This is my code

foreach (DataRow dr in sousRequete.Rows)
            {
                param = "%/ " + dr.ItemArray[0];
                if (first)
                {
                    bucket.PredicateExpression.Add(TFacturesFields.FacSId % param);
                    first = false;
                }
                else
                {
                    bucket.PredicateExpression.AddWithOr(TFacturesFields.FacSId % param);
                }
            }

But the generated sql is

AND [T_FACTURES].[FAC_S_ID] LIKE '%/ AA'
OR [T_FACTURES].[FAC_S_ID] LIKE '%/ DA' 
OR [T_FACTURES].[FAC_S_ID] LIKE '%/ AV'

() missing in my sql statement and my result is not correct.

Could you help me

Place all predicates which have to be placed inside () in a separate PredicateExpression object, and add THAT to the main predicate expression. So your predicates you add with OR should be in their own separate PredicateExpression, then you should add that one with AND to the main predicate expression.

Thanks for your response.

With this code, I obtain the correct result.

            IPredicateExpression predicat = new PredicateExpression();
            
            foreach (DataRow dr in sousRequete.Rows)
            {
                param = "%/ " + dr.ItemArray[0];
                if (first)
                {
                    predicat.Add(TFacturesFields.FacSId % param);
                    first = false;
                }
                else
                {
                    predicat.AddWithOr(TFacturesFields.FacSId % param);
                }
            }
            bucket.PredicateExpression.Add(predicat);