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