Subject | select ... for update |
---|---|
Author | Duilio Foschi |
Post date | 2002-03-03T11:34:50Z |
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
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