S
slacroixak
Guest
My way is close to Stefan's but with NO-LOCK as early as possible I wish it would be possible to align stuff to the right side of the WHERE word and the equal sign like in for an ASSIGN statement Perhaps I should revise my standard to dedicate a last line for the NO-ERROR FIND FIRST hendelseRSTO NO-LOCK WHERE hendelseRSTO.ans# = hendelse.ans# AND hendelseRSTO.son_aar = hendelse.son_aar AND hendelseRSTO.son_lnr = hendelse.son_lnr AND hendelseRSTO.Jour_lnr = hendelse.hend_lnr AND hendelse.Slettet = FALSE NO-ERROR. By the way, the following is bad for performance because progress cannot pickup an index for this: AND NOT hendelse.Slettet people should do this: AND hendelse.Slettet = FALSE Kind regards /S
Continue reading...
Continue reading...