Thanks!
How did you fix the problem?

-----Ursprüngliche Nachricht-----
Von: Martijn Tonies [mailto:m.tonies@...]
Gesendet: Freitag, 7. März 2003 13:41
An: ib-support@yahoogroups.com
Betreff: Re: [ib-support] Strange things happen to SP Parameter


Hi Andreas,

> I use the latest stable Firebird release with Delphi 5 Pro. and the

FIBPlus

> Components. In my Database there are several Stored Procedures. Some of

them

> have about 20 Parameter of different types like INTEGER or VARCHAR. Most

of

> the VARCHAR-Parameter have a length of about 100 to 255 charachters and I
> use UNICODE_FSS characterset.
>
> Now to my problem:
> After I´ve changed a SP or did something else in the DB with
> Firebird-Workbench or EMS Firebird Manager the length of my VARCHAR and

CHAR

> Parameters is changing itself!!! E.g NAME VARCHAR(200) gets to NAME
> VARCHAR(765) after I commit the changes to the SP. This stops only when
> Firebird says: '...implementation limit exceded...' and my Parameter have

a

> length of about 3000 charachters!!!!!.
>
> What´s going on? Is this a bug or a wrong DB Design on my side? Are the SP
> Parameter limited?

I can confirm this error in the Workbench tool - and I can fix it. It's NOT
an error
of Firebird, but of the client tools.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/