Anybody an idea where I can find the trouble of this message:

"Invalid custom DML Reference"

I've looked everywhere, but don't seem to find the fault.

Thanks,
Tom.

--- In IBObjects@y..., "zifnabbe" <zifnabbe@u...> wrote:
> 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.