I would *REALLY* love not to have to quote everything but I get errors
if I don't. I'm using a front-end called IBOConsole and I don't see
that I have the option *not* to use quotes.

I don't get errors from the front-end, BTW, they are firebird-level
errors.

It tells me it can't find the object if I don't quote it.

Thanks!

--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > I created a stored procedure, then I came back later to alter it and I
> > an error every time. Logging out completely and even rebooting
> > haven't fixed it, I have no idea what to do.
> >
> > Here's the error & stored procedure:
> >
> > ISC ERROR CODE:335544351
> >
> > ISC ERROR MESSAGE:
> > unsuccessful metadata update
> > STORE RDB$PROCEDURE_PARAMETERS failed
> > attempt to store duplicate value (visible to active transactions) in
> > unique index "RDB$INDEX_18"
> >
> > Statement: create procedure "sel_active_order_by_customer_id"
> > (
> > "user_id" varchar(50)
> > )
> > returns
> > (
> > "order_id" int,
> > "user_id" varchar(50),
> > "invoice_id" varchar(50),
> > "order_date" date,
> > "ship_date" date,
> > "order_status" varchar(50),
> > "payment_status" varchar(50),
> > "shipping_amt" decimal,
> > "tax_amt" decimal,
> > "order_amt" decimal,
> > "payment_message" varchar(100),
> > "avs_code" varchar(50),
> > "is_active" char(1)
> > )
>
> [snip]
>
> You use "user_id" as input and output parameter.
>
> You can't have equally named input/output parameters.
>
> Btw, is there a special reason why you want to have
> case-sensitive parameter/variable names?
>
>
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database and MS SQL Server
> Upscene Productions
> http://www.upscene.com