Function in Where clause

Posts   
 
    
tsmith
User
Posts: 38
Joined: 17-Apr-2006
# Posted on: 15-Aug-2006 19:51:18   

I am trying to create a expression that generates the following


WHERE dbo.MatchFunction([LastNameField], @LastName1, 2) = 1

currently I am getting


WHERE dbo.MatchFunction([LastNameField], "UNKNOWN", 2) = @LastName1

Code to add the Expression


IPredicateExpression filter = new PredicateExpression();
ACSMatch2 exp = new ACSMatch2(IndividualFields.LastName, ACSMatchType.Normal);
EntityField2 field = IndividualFields.LastName.SetExpression(exp);
filter.Add(field == 1);

how do I get unknown to be the paramater and the parameter to be filter value?

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 16-Aug-2006 08:08:04   

Did you check LLBLGen Pro v.2 docs "Using the generated code - Calling a database function" ?