Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Trigger get executed before autoinc is assigned
Tue, May 9 2017 5:19 PMPermanent Link

KimHJ

Comca Systems, Inc

I have a table with a generated column that have been working fine before the update to 2.25 build 5
I have a trigger: Action Time: After, Type: Insert. inserting the same record into table MainActivity.

It looks like it execute the trigger before the Integer is assigned to the generated column.

I get the following error when I try to add a record.  
ElevateDB Error #1004 An error occurred with the statement at line 8 and column 9 (The primary key constraint ID_PrimaryKey for the table MainActivity has been violated (NULL values are not allowed in a primary key)

Anyway to fix this?
Kim
Tue, May 9 2017 5:28 PMPermanent Link

KimHJ

Comca Systems, Inc

Sorry, it was the GUID in the receiving table that had lost the default setting.

Kim
Image