0 Replies Latest reply on Feb 19, 2008 11:07 PM by (Fred_Tranfield)

    ManyToMany SQL Error

      For reasons I can not understand I'm getting a null error when trying to insert a record into my database using the Many to Many wizard.

      This is what I get:

      Developer Details:
      tNG_multipleInsert error.
      An error occurred while inserting the records. (MINS_ERROR)
      ManyToMany SQL Error: Column 'workshop_id' cannot be null
      SQL: INSERT INTO teachers_crossref ( workshop_id , teacher_id) VALUES (null , 2). (TRIGGER_MESSAGE__MTM_SQL_ERROR)

      tNG Execution Trace - VIEW

      * tNG_multipleInsert.executeTransaction
      o STARTER.Trigger_Default_Starter
      o tNG_multipleInsert.doTransaction
      + tNG_multipleInsert.prepareSQL
      # tNG_insert.doTransaction
      * BEFORE.Trigger_Default_FormValidation
      * tNG_insert.prepareSQL
      * tNG_insert.executeTransaction - execute sql
      * tNG_insert.postExecuteSql
      * AFTER.Trigger_Default_ManyToMany*
      * ERROR.Trigger_Default_Insert_RollBack
      * tNG_multipleUpdate.executeTransaction
      o STARTER.Trigger_Default_Starter
      * tNG_multipleDelete.executeTransaction
      o STARTER.Trigger_Default_Starter
      * tNG_multipleInsert.getRecordset
      * tNG_insert.getFakeRsArr
      * tNG_insert.getLocalRecordset
      * tNG_insert.getFakeRecordset
      * tNG_multipleInsert.getFakeRecordset

      Apparently the insert transaction form is not gathering and passing the next id_rec to the cross_ref table.

      Ideas anyone?

      Thanks in advance.