I’m looking for a discussion on the auto enter options. Page 123 of the Users manual offers just how to define auto enter, nothing about the actual options.
What’s “database managed”? What’s the distinction between “creation datetime” and “creation server datetime”?
Supplemental auto enter options question:
I see that by defining a field as “text” I’m given the auto enter options of “creation user id” and “modification user id”. Where and how are these IDs established? Are they unique and stable? Can I perform links between these IDs and a database of names?
Is there documentation for this feature?
Couple of answers:
You can define Primary Keys on DB tables. Now, you can have your DB manage these PK’s, or let Servoy do the work. In the case that Servoy is the only application using the DB, letting Servoy handle the PK’s is not an issue. Once other programs also access, and more importantly insert into the tables, my idea is you’re better off using DB managed PK’s
About the distinction between CreateDate/time and Create Server Date/Time: The first will write into the DB field the date and time as it is on the client where the solution is running, the latter will write the timestamp of the server into the DB field. My idea is that the latter is best used, because otherwise a wrong date/time setting on a PC where the client runs will result in “wrong” date/time stamps in the DB
Regarding the UserID’s: These are the user ID’s managed by Servoy. You will have to let the users of your solutions log into your solutions, before you will get these field filled.
Hope this helps,
Paul