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...