Hi,

I get the following error, when executing this code :

with dbData.qrServiceHolidays do begin
Close;
Params.ParamByName('ServiceID').AsInteger :=
tbRadServicesSERVICE_ID.AsInteger;
Params.ParamByName('StartDate').AsDateTime := EncodeDate
(YearPlanner.Year, 1, 1);
Params.ParamByName('EndDate').AsDateTime := EncodeDate
(YearPlanner.Year, 12, 31);
ExecSQL;
Open;
First;
end;

This is the sql code:

SELECT *
FROM SERVICE_HOLIDAYS
WHERE (SERVICE_ID= :ServiceID
AND (HOLIDAY_STARTDATE >= :StartDate AND HOLIDAY_STARTDATE
<= :EndDate))
order by HOLIDAY_STARTDATE

The error:

Invalid custom DML Reference: SERVICEID

What does this mean?

Thanks in advance,
Tom.