--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@t...>
wrote:

> At 03:00 AM 28/01/2004 +0000, you wrote:
> >Previous we were using Borland Interbase. On those
> >procedures/triggers, we have using "rows" on sql select statement
> >such as...
> >
> >SELECT Mo, Opno FROM DyBdlClkTimeLog
> > WHERE Logdate = NEW.Logdate
> > AND EmpCompanyCode = NEW.EmpCompanyCode
> > AND EmployeeCode = NEW.EmployeeCode
> > AND SysAdjEndTime >= NEW.LostTimeEnd
> > ORDER BY SysAdjEndTime ROWS 1
> >(while the purpose is to select the first row of the record)
> >
> >But after come to the Firebird, this statement occur with the

error...

> >
> >Invalid token.
> >SQL error code = -104.
> >Token unknown - line 31, char 32.
> >ROWS.
> >
> >I'm wonder the "rows" doesn't work on firebird. Is that any method
> >instead of "rows" in firebird? Or the name is different in

firebird.

> >Please kindly give me some ideas. Thank you very much!
>
> SELECT FIRST 1 Mo, Opno FROM DyBdlClkTimeLog
> WHERE Logdate = NEW.Logdate
> AND EmpCompanyCode = NEW.EmpCompanyCode
> AND EmployeeCode = NEW.EmployeeCode
> AND SysAdjEndTime >= NEW.LostTimeEnd
> ORDER BY SysAdjEndTime
>
> The release notes have all the language enhancements.
>
> /hb

Thank you very very much! Thanks a lot!