I've also noticed some strange errors when changing to Dialect 3. I think
you may actually need to freshly regenerate and populate a new database to
avoid these anomalous problems.

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

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Steven Gibb" <sgibb@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, September 05, 2002 12:30 PM
Subject: [IBO] Dialect 3 Problem


> I am using IOBjects 3.6 and Delphi 5 Enterprise.
>
> The database server is Firebird 1.0.
>
> In delphi code and stored procedure code that has been stable for several
> months I am getting an error in a stored procedure. It happened when I
> changed the Dialect from 1 to 3. If I change it back to Dialect 1, the
> error goes away.
>
> I want to move the database to Dialect 3 but I can't figure out the source
> of this error.
> Can anyone suggest 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"
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>