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

    update record from insert transaction not working

    Level 1

      hi,

       

      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);
      $tNGs->addTransaction($upd_clients);
      // Register triggers
      $upd_clients->registerTrigger("STARTER", "Trigger_Default_Starter", 1, "POST", "KT_Insert1");
      // Add columns
      $upd_clients->setTable("clients");
      $upd_clients->addColumn("Status", "STRING_TYPE", "VALUE", "Case");
      $upd_clients->setPrimaryKey("ClientID", "NUMERIC_TYPE", "GET", "ClientID");

       

      hope someone can help.

       

      many thanks