Hi,

At March 16, 2004, 02:11, sayhoii wrote:

> Can anyone help to convert this statement (Interbase) in Firebird?
> Thanks!

> UPDATE DyEmpTmActNonMts SET ETagIn = :vLatestETagIn
> WHERE Logdate = NEW.TagDate
> AND EmpCompanyCode = NEW.EmpCompanyCode
> AND EmployeeCode = NEW.EmployeeCode
> AND ETagOut < NEW.LogDate
> AND ETagIn IS NULL
> ORDER BY ETagOut ROWS 1

In which version of Interbase that this statement is accepted as is?
IB6 and any version of Firebird doesn't support ORDER BY inside an
UPDATE statement. And, it isn't part of the SQL standard.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)