Forum Post: RE: Find find first for first for each can find

  • Thread starter Thread starter Thomas Mercer-Hursh
  • Start date Start date
Status
Not open for further replies.
T

Thomas Mercer-Hursh

Guest
The answer of when to use find first is never. One finds it a lot in ABL code because of a myth that it was somehow faster than a simple find. In most of those cases, the keys provided ensured a unique record so this is confusing to the reader. When the keys did not provide a unique record, then it is potentially more disturbing because it suggests treating the first record in a set differently than the rest, a violation of relational standards. You will find this and other topics at cintegrity.com/.../ABL-Best-Practice-Programming Let us know if you have other index questions.

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