I think I did. I can't find any double quotes in the metadata. I had
to change a couple column names that are reserved words in Dialect 3.

--- In ib-support@y..., "Woody" <woody.tmw@i...> wrote:
> Did you follow all directions for changing to Dialect 3, such as
changing
> all double quotes to single quotes inside procedures?
>
> Woody (TMW)
>
> ----------------------
> "To invent, you need a good imagination and a pile of junk."
> Thomas Edison
>
> From: "stevenggibb" <sgibb@n...>
>
> > I previously posted this message in the IBObjects group and
received a
> > couple suggestions but they appeared to have no effect on solving
the
> > problem. Below is one example of the type of error I am getting,
and
> > the Delphi and stored procedure code.
> >
> > I am using IOBjects 3.6 and Delphi 5 Enterprise.
> >
> > The database server is Firebird 1.0.
> >
> > In delphi code and stored procedures code that has been stable for
> > several months I am getting an errors in stored procedures. It
> > happened when I changed the Dialect from 1 to 3. If I change it
back
> > to Dialect 1, the problems go away.
> >
> > I want to move the database to Dialect 3 but I can't figure out
the
> > source of this error. I have tried rebuilding the database form
> > scratch but the results were the same.
> >
> > Has anyone else found that stored procedures work in Dialect 1 and
> > failed in Dialect 3. If not, then it must be something in my code.
> >
> > Can anyone suggest where to look or a solution?
> >
> >
> > *******The stored procedure code*************
> >
> > CREATE PROCEDURE DELETECONTACTTEMP (
> > EMPLOYEE CHAR (6))
> > AS
> > BEGIN
> > DELETE FROM CONTACTTEMP WHERE EmpID = :EMPLOYEE;
> > SUSPEND;
> > END
> >
> > *******The delphi code*************
> >
> > with DM_StoredProc.spDelContactTmp do
> > begin
> > // insertcontactlabeldata
> > DatabaseName := gsDataBaseName;
> > StoredProcName := 'deletecontacttemp';
> > Prepare;
> > ParamByName('EMPLOYEE').Value := gsEmpID;
> > try
> > ExecProc;
> > except
> > on E: Exception do
> > MessageDlg(rsErrMsg2, mtWarning, [mbOK], 0);
> > end;
> > UnPrepare;
> > end;
> >
> > *******The error message*************
> >
> > ISC ERROR CODE:33544569
> >
> > ISC ERROR MESSAGE:
> > Dynamic SQL Error
> > parameter mismatch for procedure DELETECONTACTTEMP
> >
> >
> > STATEMENT:
> > TIBOInternalDataset: "spDelContactTmp.IBOqrspDelContactTmp"