Auto enter option re: creation date, modification date, etc.

Classic Servoy
1

I think that Servoy had an auto enter option for creation date, modification date, modification user, etc. I don’t see that anymore.

Any work around?

I am using Servoy version 5.1.2 -build 959, Repository version 38.

These are the fields I’d like to set with auto enter:

Capture.GIF
Capture.GIF417×230 10.6 KB

2

jcarlos,

These auto enter values are configured and managed in Servoy, not in the db table definition.
Edit the table, select the date column, select the Auto-enter tab, option System-value gives the auto-enter values.

Rob

3

Rob, thank you very much for your prompt response. I understand, Servoy has an auto enter option for creation date, modification date, modification user, etc. The problem is that I can’t set that up – or I don’t know how to do this now.

I’ve done what you said. Edit Table/View, select a row (e.g. document_content_creation_dt), select the Auto-enter tab, select System-value. The problem is that System Value only gives me two auto-enter values/options: ‘none’ and database managed.’

Is that Ok?

Any work around?

Capture.GIF
Capture.GIF761×577 72 KB

4

jcarlos,

I found out why the auto-enter options were not showing for your timestamp columns.
That will be fixed in version 5.2.

Rob

5

I understand. For now, the only way to do this is programmatically. I will set the auto enters after 5.2 GA release.

However, I’d like to know what happens here. Is it something that I am doing wrong or not understanding in the UI?

Weren’t the auto enter options supposed to be working in 5.1, 5.0?

I really don’t want to set the auto enter values in Servoy 5.2 and then run into problems after subsequent releases of Servoy.

What do you recommend? Should I do this programmatically and forget about the auto enter options entirely?

Thanks!

JC

6

JC,

The issue was purely in the table editor, the UI got confused if the column type was timestamp in stead of datetime.

Rob

7

I see. The issue with the timestamp and table editor is a bug and it will be fixed in 5.2

Still, the problem is that the auto enter options are not showing for the other fields I’d like to set with auto enter. Again, I have a problem with setting up auto enter in Servoy for:

document_content_creation_dt (type: date)
document_content_creation_time (type: time)
document_content_creation_user (type: char(10))

The issue that I am experiencing is not just with the ‘timestamp’ data type. The problem is that System Value only gives me two auto-enter values/options: ‘none’ and database managed’ for all data types (not just timestamp)

8

I think that fix will also fix those issues.
Then date or time is also seen as a datetime field in servoy (same for char seen as the default servoy type varchar)