🚀 go-pugleaf

Yes.

So when I attempted to create the procedure the first time.
The system gave up half way through.

I reckon Interbase does not like meta data changes.
This is bad news for us.
Since we generate temporary external tables and procedures to upload then
then we drop them.

I am at the point of giving up on interbase.

The stuff I am doing worked perfectly in IB7 and also works in IB6.

Yet seems to fail in IB8.

Not good.

Kind Regards,

Robert.

"Wayne Niddery (TeamB)" <wniddery@chaffaci.on.ca> wrote in message 
news:471ff44c$1@newsgroups.borland.com...
> "Bob" <Bob@Bob.com> wrote in message 
> news:471fe3e2$1@newsgroups.borland.com...
>>I get the following Error, The Stored Procedure is not preexistant :
>>
>> ISC ERROR CODE:335544351
>>
>> ISC ERROR MESSAGE:
>> unsuccessful metadata update
>> STORE RDB$PROCEDURE_PARAMETERS failed
>> lock conflict on no wait transaction
>> attempt to store duplicate value (visible to active transactions) in 
>> unique index "RDB$INDEX_18"
>>
>>  DO SUMETHING;
>
>
> No way for anyone guess what the above does, but a good guess is that's 
> where the error is begin generated, and it will be just what it says - an 
> attempt to add duplicate field(s) values for fields that have a unique or 
> primary key constraint.
>
> -- 
> Wayne Niddery - Winwright, Inc. (www.winwright.ca)