Hi mike,

FLUSH usually is useless in such situation. It flushed the writebuffers, but since the files are shared theyre flushed to the server anyways. FLUSH only serves when using files exclusively or when you're the only one using this shared table and the file server uses opportunistic locking.

Walter,

>UNLOCK was the solution, thanks for the reminder about 2 parameters, though, made me read Hackers Guide again, and , luckily for me,
>
>set refresh to 1 compiles as set refresh to 1,1 ( the first parameter controls the second! )
>
>Still don't understand why UNLOCK works and FLUSH doesn't !
>
>thx
>
>mike