Don,
you use FOR UPDATE correctly. The OF part is optional and there's nothing
more to it (so there's not much to explain). If company exists in your
database it should get back all the records of your that table.

Set

At 10:58 23.03.2001 +0200, you wrote:

>Thanks for the information,
>
>I've never used the FOR UPDATE statement before but I quickly tried it out
>like this:
>
>SELECT * FROM company
>FOR UPDATE OF company_no
>
>I'm not sure if this is correct since the query does execute but an empty
>result set is returned without any fields.
>
>The IB help on FOR UPDATE is a bit vague.
>
>-Don