0 Replies Latest reply on Mar 28, 2011 4:14 AM by deansy55

    update record from insert transaction not working

    Level 1



      i have an insert form generated by addt which works fine, however i have added an update transaction to this, to be triggered from the insert form submit button.


      however it does not update the table:


      this is the update code:


      // Make an update transaction instance
      $upd_clients = new tNG_update($conn_cbank);
      // Register triggers
      $upd_clients->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
      // Add columns
      $upd_clients->addColumn("Status", "STRING_TYPE", "VALUE", "Case");
      $upd_clients->setPrimaryKey("ClientID", "NUMERIC_TYPE", "GET", "ClientID");


      hope someone can help.


      many thanks