Subject | HAVING Clause in Firebird vs. Interbase |
---|---|
Author | mthendley |
Post date | 2007-11-26T16:32:24Z |
When using Interbase, we had the following HAVING clause in a query,
which is not allowed in Firebird. Any suggestions on how to rework
this in Firebird? Let me know if you need more info.
HAVING (sch_StartTime+0.00348) < (f_StripDate(Min(CheckInTime))-1)
OR (sch_EndTime-0.00348) > (f_StripDate(Max(chk_CheckOutTime))-1)
Thanks
which is not allowed in Firebird. Any suggestions on how to rework
this in Firebird? Let me know if you need more info.
HAVING (sch_StartTime+0.00348) < (f_StripDate(Min(CheckInTime))-1)
OR (sch_EndTime-0.00348) > (f_StripDate(Max(chk_CheckOutTime))-1)
Thanks