Technical key, integer
Author: firstname.lastname@example.org (rogerw)
Hi, It's very silent here, so below some working code (write-trigger) that would need some explanation. I'm simulating a technical integer key that is added with +1 for every new occurrence written to the database. The testId integer-column of table test has Syntax: "HID,LEN(0-0)" to avoid complaints about empty key. The code should work as one occurrence is added and then stored. But I dont understand that it works, adding two or several occurrences before storing. Shouldn't sql "select max(testid) from test","def" return the same max value until something is committed to the database?