Since no other is replying you...
I just know that "FOR UPDATE" is equivalent of setting "RequestLive" for the queries.
I don't know if is a SQL or a IB specific information sent to the server to inform it that the query will be updatable.
Regards
Marco Menardi

--- In IBObjects@y..., Duilio Foschi <dedalus@y...> wrote:
> this is something I read in one of the sample programs.
>
> with TIB_Cursor.Create(nil) do
> try
> ...
> SQL.Strings = (
> 'Select'
> ' EMPLOYEE.EMPNO,'
> ' EMPLOYEE.LASTNAME,'
> ' EMPLOYEE.FIRSTNAME,'
> ' EMPLOYEE.PHONEEXT,'
> ' EMPLOYEE.HIREDATE,'
> ' EMPLOYEE.SALARY'
> 'From EMPLOYEE'
> 'FOR UPDATE')
> ...
> finally
> Free;
> end;
>
> What is the meaning of the _for update_ clause ?
>
> Is this standard SQL ? (I cannot find it in the IB LangRef)...
>
> TYIA
>
> Duilio Foschi