0 Replies Latest reply on Mar 30, 2009 4:55 PM by (Jeff_Darst)

    insert page

      hello,
      I have been trying for a while to build an add new insert page that gets values from one table (a)and inserts the informaion along with informaion in table (b) ino table (b. I get this error

      Error:
      An error occurred while inserting the records.
      SQL error: Cannot add or update a child row: a foreign key constraint fails (`whole7_FormProcess`.`patient_information`, CONSTRAINT `patient_information_ibfk_4` FOREIGN KEY (`id_office`) REFERENCES `login` (`id_office`) ON DELETE CASCADE ON UPDATE CASCADE).
      Developer Details:
      tNG_multipleInsert error.
      An error occurred while inserting the records. (MINS_ERROR)
      SQL error: INSERT INTO patient_information (patient_first_name, patient_middle_initial, patient_last_name, patient_address, patient_city, patient_state, patient_zipcode, patient_phone, patient_sex, patient_date_of_birth, patient_social_security_number, patient_insurance_info) values ('m', 'm', 'm', 'm', 'm', 'm', 'm', 'm', 'm', 'm', 'm', 'm'). (SQL_ERROR)
      tNG Execution Trace - VIEW
      tNG_multipleInsert.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_multipleInsert.doTransaction
      tNG_multipleInsert.prepareSQL
      tNG_insert.doTransaction
      BEFORE.Trigger_Default_FormValidation
      tNG_insert.prepareSQL
      tNG_insert.executeTransaction - execute sql*
      ERROR.Trigger_Default_Insert_RollBack
      tNG_multipleUpdate.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_multipleDelete.executeTransaction
      STARTER.Trigger_Default_Starter
      tNG_multipleInsert.getRecordset
      tNG_insert.getFakeRsArr
      tNG_insert.getLocalRecordset
      tNG_insert.getFakeRecordset
      tNG_multipleInsert.getFakeRecordset

      Thank You

      Jeff