Hi,

how do you update Stored Procedures on the client's machines? I wonder
if there can be realized something like a version control for procedures.

One idea would be to create a table that holds the name and the version
of a procedure thus allowing a comparison when the application starts.
But that seems to be a lot of work and not that reliable.

Any ideas how to manage this are appreciated...

Regards Uli

Uli,

<< One idea would be to create a table that holds the name and the version
of a procedure thus allowing a comparison when the application starts. But
that seems to be a lot of work and not that reliable. >>

Version numbers for functions/procedures will be included in 2.03, so that
may help.  Other than that, a comparison of the textual representation of
the SQL/PSM code is the only other way.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim ,

> Version numbers for functions/procedures will be included in 2.03, so that
> may help.  Other than that, a comparison of the textual representation of
> the SQL/PSM code is the only other way.

Great! That will help indeed. (I didn't have the heart to ask for this
feature )

Uli