What I've got is something like this

SET REPROCESS TO AUTOMATIC
SELECT NextRef
=FLOCK()
Read the number
increment the number
write it back
unlock

Am I right in thinking that with reprocess set to automatic the flock() function will attempt over and over again to lock the file until a successful lock is placed? In which case it the code below the call to flock() will never be executed unless the file is locked.