Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 2 of 2 total |
Trigger get executed before autoinc is assigned |
Tue, May 9 2017 5:19 PM | Permanent 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 PM | Permanent Link |
KimHJ Comca Systems, Inc | Sorry, it was the GUID in the receiving table that had lost the default setting.
Kim |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |