i have a class with three independent codes. Depending on situation i need to search using one of the three. Could i use the Find method?
Using Find:=True in attributes atoms generate a SQL with AND (p1 and p2 and p3).
I need sometimes:
select .. where p1=..
others
select ... where p2=..
others
select .. where p3=..
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i have a class with three independent codes. Depending on situation i need to search using one of the three. Could i use the Find method?
Using Find:=True in attributes atoms generate a SQL with AND (p1 and p2 and p3).
I need sometimes:
select .. where p1=..
others
select ... where p2=..
others
select .. where p3=..
Thanks
No. The Find() method uses _all_ attributes that are flagged as find="true", not just some.
You will need to use a CRetrieveCriteria and add a SelectEqualTo criteria to the WhereCondition, something like
rc.WhereCondition.AddSelectEqualTo("myAttribute",myObj.Value)
- Richard.