1 2 3 4 5 6
| sSql = "INSERT INTO T_CONTRAT_AVENANT ( ID_AFF, NUM_CT, NUM_OP_SPECIFIQUE, NUM_AUTRE, DATEINI, REF, NUM_CNTTAV, DTEDEB_CNTTAV, DTEFIN_CNTTAV, COMMENTAIRE1, INFOS, COMMENT_ANNEXE_CNTT, DATE_DEMANDE, TYPE_DEMANDE, REF_DEMANDE, DATEENVOICP, DATEDEPARTCT, DATERETOURCT, DATEFINCT, DATE_FERMETURE, CODE_AVANCEMENT, BL_ANNULE, COM_ANNULE, DTE_ANNULE, COMMENT_CNTTAV, COMMENT_CNTTAV_CP, " _
& "BL_APPLICATION_COEFF_MO, CTRL_CNTTAV1, CTRL_CNTTAV2, CTRL_CNTTAV3, DTE_CREA, DTE_MAJ, CONDITION_ECO, Num_FEB )" _
& " SELECT " & newidaf _
& ", NUM_CT, NUM_OP_SPECIFIQUE, NUM_AUTRE, DATEINI, REF, NUM_CNTTAV, DTEDEB_CNTTAV, DTEFIN_CNTTAV, COMMENTAIRE1, INFOS, COMMENT_ANNEXE_CNTT, DATE_DEMANDE, TYPE_DEMANDE, REF_DEMANDE, DATEENVOICP, DATEDEPARTCT, DATERETOURCT, DATEFINCT, DATE_FERMETURE, CODE_AVANCEMENT, BL_ANNULE, COM_ANNULE, DTE_ANNULE, COMMENT_CNTTAV, COMMENT_CNTTAV_CP, BL_APPLICATION_COEFF_MO, CTRL_CNTTAV1, " _
& " CTRL_CNTTAV2, CTRL_CNTTAV3, DTE_CREA, DTE_MAJ, CONDITION_ECO, Num_FEB FROM T_CONTRAT_AVENANT " _
& " WHERE ID_AFF=" & Me.ID_AFF |
Partager