Fwd: A question regarding the "rows" on select SQL statement.
>Date: Wed, 28 Jan 2004 03:03:11 -0000
>From: "sayhoii" <sayhwee@...>
>Subject: A question regarding the "rows" on select SQL statement.
>Previous we were using Borland Interbase. On those
>procedures/triggers, we have using "rows" on sql select statement
>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
>But after come to the Firebird, this statement occur with the error...
>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 firebird.
>Please kindly give me some ideas. Thank you very much!