Is it possible to batch change Servoy properties via SQL?

Classic Servoy
1

Hi all,

Let’s say I want to check that all fields of a certain type have a certain property set, regardless of which form they are on… Let’s say we have 2,500 fields spread out on 400 forms which all need to have the same onFocusLost or onDataChange script…

If I look at the Servoy-Repository database with DBViz or a similar tool, I can write SQL queries on this to locate the fields to fix… Now, with a bit of care, it should also be possible to do a batch update via SQL as well… or will Servoy get upset??? I suspect I need to close the solution first…

2

if you are going to do that then don’t do it when you have a running developer or server. And do make a backup of youre repository server!

3

jcompagner:
And do make a backup of youre repository server!

Of course!

:slight_smile: The most important finding is that we are able to search the repository. And we have an equivalent to MetaDataMagic when moving projects over to Servoy.