Oops, sorry, my mistake, I just copied some code and adjusted it,
forgot to remove that part.
However, I still get the error :-(.

Tom.

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> 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@u...>
> To: <IBObjects@y...>
> 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.