null pk_data in Log on new record

Classic Servoy
1

I just started working with the log and I have a few questions/concerns…

When a user creates a new record, the log shows “.null;” for the pk_data. Is the log being written before Servoy knows the pKey? Is there a work around or is there a way to get this corrected?

Secondly, I also notice in the log, in the pk_data field, “2.46;5.78115;” does that mean they were editing a record through a relationship? What is the purpose for storing the pKey this way?

I am trying to show a list of edits on a record using a tab panel. My log is located in a seperate database and I am creating the key on the entity end to match the key on the log table, but I do not understand this dual key and its purpose. I need to modify my calc and relationship to somehow still be able to relate this log record (“2.46;5.78115;”) back to its entity (46).

These 2 things are causing me a headache. Can you post some detailed info on the how/why Servoy stores the pKEy in this way? Perhaps with a better understanding of what is going on I may be able to rethink my solution.

2

about the null. What sequence do you use for the pks? Do you also have this with the latest RC (rc7).

you use a record that has 2 columns as his pk

2.46;5.78115;

2 > the string length of the first pk column
. > seperation between length and key
46 > the value
; > seperation between 2 keys
5 > string length of the second pk column
. > seperation
78115 > the value

This way the keys stored are always unqiue

3

I use the databse sequence for the pk’s.
Yes I have it in rc7.

I only use 1 field as the pk, not 2. Any ideas why it would think there are 2? How does servoy define a pk? I only have 1 field set as pkey in mysql.

I thought that this would be addressed in the next revision (per ichat conversation we had a few weeks back) but I did not see a reference to this in the new change list for rc8.

I have not done detailed testing yet in rc8 but I wanted to follow-up on this issue and see if it is “on the board” or not.

4

if you are using database sequences then you also point to that sequence that you made in the database?
Does that sequence work if you ask the db youreself?

But i see that you use mysql but mysql has db_identity (auto increment) does it also have a sequence?

about the 2 are you sure that you didn’t specify that there are 2 ident columns?