BruceD Lindberg
Member
Can some one explain how using FIRST in FIND statements is wastefull?
ie)
FIND FIRST table1 where RECID(table1) = RECID(table2) NO-LOCk NO-ERROR.
FIND FIRST table1 where table.key1 = v-key1
and table.key2 = v-key2 no-lock no-error.
(assume key1 & key2 make up the primary unque index)
ie)
FIND FIRST table1 where RECID(table1) = RECID(table2) NO-LOCk NO-ERROR.
FIND FIRST table1 where table.key1 = v-key1
and table.key2 = v-key2 no-lock no-error.
(assume key1 & key2 make up the primary unque index)