Related field update with db identity

Classic Servoy
1

Master table pk is set as auto_increment on backend database (mySQL in my case) and db identity on Servoy.

Then, if you create a master record, edit fieldA, create a related record, then change fieldA again, the related record will be unaware of the change during your session (or maybe if you update it somehow).

Sometimes even if fieldA already has a value and you create a related record this record will not be able to show the current value.

If sevoy seq is used there is no problem.

(Note: I’m using someone else’s posted sample to illustrate, can’t remember who’s, sorry)

2

if you use db sequences and you want to create new related records on a parent record that has a db seq. Please save the parent file first. That is the safest way to do it. We have some support for these things but it will never work 100%.
You have to be very carefull with this situation.