Periodically make a backup of the database and restore it to a
different, development
database. Once the SP is complete, then create it on the live. This
should help when
making those last 5 or 6 corrections.

Valdir Stiebe Junior wrote:

>Thanks to everyone.
>This happen here because we use a test gdb with a lot of client data to
>design reports. And the report builders team have 4 programmers, so they are
>always fighting to everyone disconnect because the SP didn't changed.
>
>Valdir.
>----- Original Message -----
>From: "Helen Borrie" <helebor@...>
>To: <ib-support@yahoogroups.com>
>Sent: Thursday, September 26, 2002 9:01 PM
>Subject: Re: [ib-support] This is a bug???
>
>
>
>
>>At 06:08 PM 26-09-02 -0300, you wrote:
>>
>>
>>>Hi.
>>>Sometimes when editing a stored procedure while someone else is also
>>>connected on gdb and alter the parameters data type this change only has
>>>effect after everybody (including me) disconnect from the gdb.
>>>An example, changing a parameter datatype from varchar(4) to varchar(10).
>>>Anyone have tha same problem??
>>>
>>>
>>This is "as designed". Changes to stored procedures and triggers are
>>deferred until there are no remaining transactions in the system that are
>>involved in dependencies with that code.
>>
>>As ever, it's not good policy to attempt to implement metadata changes on
>>
>>
>a
>
>
>>database while users are active in it.
>>
>>heLen
>>
>>
>>
>>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/
>>
>>
>>
>
>
>
>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/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com



[Non-text portions of this message have been removed]