C
ChUIMonster
Guest
If you do the "IF CAN-FIND() THEN FIND..." thing: 1) Keep in mind that that is not an atomic sequence of events. The record could be deleted or have it's key updated between the CAN-FIND() and FIND statements so you still need to be prepared to somehow address possible errors with the FIND. 2) You will have two WHERE clauses to keep in sync. Which means extra opportunities for bugs to infest your code. Frankly, I would just FIND the darned record. The use cases for only checking existence are, IMHO, few and far between and the benefits mostly miniscule. Keep it short and simple.
Continue reading...
Continue reading...