Then you have to deal with security.

Artur Anjos wrote:

>If the SP does not have any dependency, you can just 'DROP' it and 'CREATE'
>it. That will work.
>
>Artur
>
>----- Original Message -----
>From: "Daniel Rail" <daniel@...>
>To: <ib-support@yahoogroups.com>
>Sent: Thursday, September 26, 2002 10:31 PM
>Subject: Re: [ib-support] This is a bug???
>
>
>
>
>>At 26/09/2002 06:08 PM, 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??
>>>
>>>
>>That is how it is designed. The stored procedures are compiled on the
>>first connection to the database. Just to let you know that MS-SQL
>>operates the almost the same way, the stored procedure is compiled the
>>first time it is called after SQL Server is started, but can be forced to
>>recompile, by using a built-in function, the next time the stored
>>
>>
>procedure
>
>
>>is called.
>>
>>
>>Daniel Rail
>>Senior System Engineer
>>ACCRA Group Inc. (www.accra.ca)
>>ACCRA Med Software Inc. (www.accramed.ca)
>>
>>
>>
>
>
>
>
>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]