It doesnt appear to be your problem - bt there is one gotcha with dialect 3.

The SQL spec is stupid and multiple interpretations cause confusion. For
mixed case identifiers you need to use quotes. However if you use all
uppercase identifiers, most things will treat them as dialect one
identifiers.... this can cause some recognition problems.

----- Original Message -----
From: "Steven Gibb" <sgibb@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, 6 September 2002 7:30 AM
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"
>
>
> Yahoo! Groups Sponsor
> ADVERTISEMENT
>
>
>
>
___________________________________________________________________________
> 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 the Yahoo! Terms of Service.
>
>