One other comment,

I am using the IBO version 4.8 Beta2 for testing, Delphi 6 and
Firebird version 1.5.3. I had the same problem with IBO version 4.7.

Thanks

Jack

--- In IBObjects@yahoogroups.com, "jack_engleman" <jengleman@...> wrote:
>
> Jason
>
> I am using databases that are Dialect 1 and I will change to Dialect 3
> once my customers get into their off season in December and January.
> I can run a command file using isql and not get any errors, but I
> cannot use ib_script to execute the file because I get the below error
> on all stored procedures that passes a numeric parameter as below.
> I have a set SQL dialect 1 command in the front of all command files.
> All other stored procedures without Numeric parameters are compiled
> correctly in IB_Script.
>
> ALTER PROCEDURE UPBTURN (B VARCHAR(10), P NUMERIC(15, 2))
> AS
> BEGIN
> UPDATE BARCODES
> SET OUT = OUT + 1, EARNED = EARNED + :P
> WHERE BARCODE = :B;
> END
> ISC ERROR CODE:335544569
>
> ISC ERROR MESSAGE:
> Dynamic SQL Error
> SQL error code = -817
> Metadata update statement is not allowed by the current database SQL
> dialect 1
>
> I believe that maybe the Numeric parameter is being passed as a
> dialect 3 value, since the same stored procedures are handled
> correctly by isql.
>
> If you need a sample program and database, I can send you one.
>
> Jack
>