How FIND finds

[Stoycho]

Hi.

Is there someone who knows how exactly is implemented the FIND statement in PROGRESS? I am interested in the following:

FIND sometable where RECID(sometable) = ? NO-LOCK.

Is the above statement really searching for a record with null recid, or there is some initial checks for this situation made in the FIND implementation before the real search?

 

[MurrayH]

No idea, it doesn't make sense to search for a NULL recid anyway .. does it?? Can't think of why you would. When searching for a NULL record I think you will find it actually does the search so I doubt if its smart enough to recognise the "recid" bit.

Murray