--- In firebird-support@yahoogroups.com, Daniel Rail <daniel@a...>
wrote:

> 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)

Yes. U r right. Thank you for reply me. I also wonder this statement
was accepted in IB6. I'm halt in here... If this is not supported or
no other substitution, then I have to write some more code in front
of it...