|Subject||Re: A question regarding the "rows" on select SQL statement.|
--- In email@example.com, Helen Borrie <helebor@t...>
> At 03:00 AM 28/01/2004 +0000, you wrote:error...
> >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
> >Invalid token.
> >SQL error code = -104.
> >Token unknown - line 31, char 32.
> >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
> >Please kindly give me some ideas. Thank you very much!Thank you very very much! Thanks a lot!
> 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.