Why are you calling ExecSQL?
That method is what you call to execute a non-select SQL statement.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "zifnabbe" <zifnabbe@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, June 11, 2002 5:17 PM
Subject: [IBO] Invalid custom DML Reference?


> 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.