I tried the code:

It finds the "ccode" always, whether it has been previously in the file or not.

I am using pessimistic record locking.

Is there anything else I should be looking at?