[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: can-find: resolved where?

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
Let's say you have a unique index on two fields (fieldA and fieldB) and one field not in any index (fieldC). If you have a unique index on fieldA and fieldB, there can only be zero or one records matching your where clause. So instead of using CAN-FIND, why not just FIND the record with fieldA and fieldB in the WHERE clause and then evaluate the value of fieldC in the record buffer?

Continue reading...
 
Status
Not open for further replies.
Back
Top