creation/modification datetime

Classic Servoy
1

Question: Can we run a script to set attributes to auto entered values like “creation datetime” (without having to open settings windows in Servoy for each attribute)?

We hope to avoid something like this for all our creation and modification date attributes:

UPDATE servoy_columninfo
SET columninfo_id = 10055
auto_enter_type = 1
system_value = 8
WHERE connection_name = ‘’
AND tablename = ‘

’
AND columnname = ‘’;

(Would this work? Any experience?)

Background: Our problem is, that we have an import process which creates and fills about 150 tables with about 1500 attributes with data from an earlier release of our application. This import process will not only run once but several times. One reason for this is, that we will develop the new release of our application within the next year and improve and automate the import process in parallel. So we are prepared for the final switch to the new release. The other reason is, that during development and testing we probably will break test data every now and then. So we are looking for an automated import process which creates all the tables and fills in all the data. We don’t want to open settings windows for each column every time.

Thanks for any help and regards
Birgit Rieder
Robert Huber

2

Birgit,

I strongly advise against accessing the servoy repository database directly.
It is strictly for internal use and the structure may change over every (sub)release breaking your code.

Servoy keeps information about tables and columns in its repository.
When tables are dropped and recreated with exactly the same names while servoy is not running the column info will no be lost and the setting for the columns are kept.

Additionally, the table structure is stored in the solution export files, you can use your solutions (or a special one just for the column info) as a backup.
When you import it the column info will be updated.

Hope this helps,

Rob

3

Thank you, Rob, for this response.

That coulmn info will not be lost whenever we create the same database schema, without Servoy running, will help us a lot. So we only once have to enter column info in Servoy. And then only again if we change table format when creating the db again.

Best regards
Birgit