| Subject | A sql statement help request... |
|---|---|
| Author | sayhoii |
| Post date | 2004-03-16T06:11:30Z |
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
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