Hi Tim,

I'm setting up a stored procedure to set the version number of all Tables, Functions, Stored Procedures and Views.

Altering the version number of tables is easy as only the version needs to be provided, but altering Functions, Stored Procedures and Views is awkward because other elements have to be included.

Would it be possible at some point in the future to allow version numbers to be changed for Functions, Stored Procedures and Views without having to specify other elements?

= Steve

Steve,

<< Would it be possible at some point in the future to allow version numbers to be changed for Functions, Stored Procedures and Views without having to specify other elements? >>

Yes, this is already on the list, so I will try to bump it into the next round of updates.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

<< Yes, this is already on the list, so I will try to bump it into the next round of updates. >>

Thanks, that would be great.

= Steve

< Tim Young [Elevate Software] wrote:
< Yes, this is already on the list, so I will try to bump it into the next round of updates.

Hi Tim, any news for this? At the moment we can't change the Version of views without declaring the definition. In my case i have to grant rights for view + setting their version but can't do it
--
Yusuf Zorlu
MicrotronX

Yusuf Zorlu wrote:

< Tim Young [Elevate Software] wrote:
< Yes, this is already on the list, so I will try to bump it into the next round of updates.

Hi Tim, any news for this? At the moment we can't change the Version of views without declaring the definition. In my case i have to grant rights for view + setting their version but can't do it
--


Is it not possible to do a

GRANT SELECT, INSERT, UPDATE, DELETE ON VIEW "myview" TO "xxxUsers"

+ and after this

ALTER VIEW "myview" AS
.... definition ...
VERSION 1.2

In my case i get a #1007. Both SQL are run over same session.
--
Yusuf Zorlu
MicrotronX

Yusuf Zorlu wrote:

Is it not possible to do a

GRANT SELECT, INSERT, UPDATE, DELETE ON VIEW "myview" TO "xxxUsers"

+ and after this

ALTER VIEW "myview" AS
.... definition ...
VERSION 1.2

In my case i get a #1007. Both SQL are run over same session.
--

Solved: I had a SENSITIVE Query for "select * from information.views where version<1.2" and looped through the rows + doing grant and setting version ... in that case the #1007 was showed for the query.next and not for the "ALTER VIEW..."
--
Yusuf Zorlu
MicrotronX