Gen EDGE

  • 1.  SQL Statement for Update Primary Key in CaGEN

    Posted Aug 14, 2018 07:56 PM

    Hello, i have a problem in sql statement for update primary key in toolset..

     

    This is the way a create to update a primary key column in database... the consistency check no error just warning buat when i try to generation for build it show the build failed.

     

     

    If I comment the Delete statement in READ statement the build it fine. Do you know how to update the column of primary key?



  • 2.  Re: SQL Statement for Update Primary Key in CaGEN

    Posted Aug 14, 2018 08:06 PM

    This isn't so much an update as a delete and create pairing.  Theory is this should be perfectly valid.

    Check to ensure your data model is up to date and has been properly transformed.

    Ensure that your RI triggers have been built successfully - it could be failing to link to a cascade member.

    If that's still failing, please provide the output of the build failure (right click on it and choose Review ,or hit F4).



  • 3.  Re: SQL Statement for Update Primary Key in CaGEN

    Posted Aug 14, 2018 08:49 PM

     

    this is the review on build tools..buat i can't understand what it is.



  • 4.  Re: SQL Statement for Update Primary Key in CaGEN
    Best Answer

    Posted Aug 14, 2018 09:14 PM

    Text is better than pictures where possible, but given the naming of E0001185, it's probably an RI trigger.

     

    Build your RI triggers before you build this code.