|
Log in |
FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]() Hello,
I need some advice on the following problem. I have a NexusDB server with many aliases. Each alias contains data of the same structure. One of the aliases is the main working one, the others are different years of stored data. In the main alias I have created stored procedures, functions, views. I would need some advice on how to call a stored procedure/function/view from the main alias, but with it being executed over the alias I specify. Currently, the same procedure/function/views are created in each alias, but to update them, this duplication is very undesirable. Is there any way to resolve this? Thank you for any advice. Best regards Martin |
#2
|
|||
|
|||
![]() Hello
I just found that in the sql section of this newsgroup there is almost the same query with the answer NOT SUPPORTED. However, I think it is beneficial to share stored procedures/functions/views between different databases. Thank you Martin |
#3
|
|||
|
|||
![]() On 20/01/2025 10:31, radvansky wrote:
> > However, I think it is beneficial to share stored > procedures/functions/views > between different databases. Could you not write yourself a function in the main database that replicates the procedures/functions/views to the other databases ? David |
#4
|
|||
|
|||
![]() Hi,
Yes, I can do it, but again, we have a lot of aliases. Each alias contains company accounting data for a single year. In the case of replication of sp/fnc/view, I still have a lot of redundant code. With some database upgrades, it will end in an uncluttered state. Thanks for the answer Martin |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Stored Procedures | Tony Grant | nexusdb.public.support | 6 | 9th March 2020 04:08 PM |
help for stored procedures | Daniele | nexusdb.public.support.sql | 8 | 8th August 2006 07:49 PM |
Help for stored procedures | Daniele | nexusdb.public.support | 5 | 7th August 2006 04:44 AM |
Re: Stored Procedures | Martijn Tonies | nexusdb.public.support.sql | 1 | 16th September 2005 10:15 PM |
Re: Stored Procedures | Wolfgang | nexusdb.public.support.sql | 0 | 16th September 2005 06:39 PM |