Hello everyone, this is my first post to this forum. I was nearly dragged into the simplicity of FileMaker before I saw the light. Servoy has been a huge learning curve over the last week, but I’ve finally got a shared database up and running and it’s great.
I’ll have several questions, and will do my best to search the forums before posting them. Excuse me if I ask a question that’s already been answered in the early days, and thanks in advance for your help.
So, in FileMaker Pro I used to create so-called housekeeping fields for each table, for tracking purposes. Namely creation and modification timestamps, and users. Is there an easy way to do this in Servoy, for example cutting-and-pasting once created once?
Or indeed am I missing the bigger picture, perhaps there’s another way to store creation and modification data in Servoy without explicit auto-enter fields?
Thanks in advance
Ben
Hi Ben, and welcome!
You should take a look at the tracking facilities - you have to define one of your database servers as a log server, and then for each table you want to track per group in the security, use ‘Explicit’ and check ‘Tracking’ - from then on, each operation you do on that table when logged under the group you have associated with it will be logged into a log table - the easiest is to create a Tracker group and associate all users to it during login.
I cannot find a public page on the wiki to explain these concepts, there is one under construction though, and in the ServoyDev4UserGuide.pdf there are some guidelines (check page 587 to 590) which are still accurate.
Hope this helps,
Thank you for your reply, I must say you’re a great bunch of people on this forum. So helpful and welcoming ![:-)]( "Smile")
I would still like to include housekeeping fields, so I can easily read when and by whom a record was created / modified.
Is there an easy way to copy and past fields from one table to another in Servoy, or should I use my Sybase tools?