At 09:12 PM 03-12-01 +0200, you wrote:

>Hi all
>
> Do I have to add "FOR UPDATE" for all slave datasets in the masterlink relationship

I never do.

AFAIK, it has no significance in a dynamic SQL statement in InterBase. Its use is in the SELECT clause of a DECLARE CURSOR statement, for marking columns that can be updated using a WHERE CURRENT OF clause (embedded SQL).

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________