Wierdness: Auto Enter Lookup w/ global var

Classic Servoy
1

Get this:

I’m using a lookup global variable for a column auto-enter.

I am finding that the value in the column is changing when the global variable changes. This change can even happen across servoy sessions. I can create a record, save it, re-launch servoy, change the global variable and the value in the column will change.

(I should point out that the column and the global var are FROM keys in relations - but I don’t see how this affects anything)

I don’t understand why. Shouldn’t auto-enter look ups only insert the value when the record is created?? After that, the value of the column shouldn’t change, regardless if the item that was looked-up has changed. Right??

As a workaround, I removed the auto-enter and instead used the table event ‘on record insert’ and set the value of the column with the same global variable and the strange behavior went away.

I have reproduced this behavior with several tables.

Servoy Developer
Version 3.5-build 513
Java version 1.5.0_10-b03 (Windows XP)

2

don’t understand why. Shouldn’t auto-enter look ups only insert the value when the record is created?? After that, the value of the column shouldn’t change, regardless if the item that was looked-up has changed. Right??

That is how I interpreted it!
You say you can reproduce it. My suggestion is to create a small sample solution and add it to the support system.