1 2
| StrSQL = "INSERT INTO LotsActes (PROID, TPLID, CLIID, LOTDatCreat, LOTDatReserv, LOTTVA, LOTRem, LOTHT, LOTTTC, LOTHTConf, LOTTTCConf, LOTImRef, LOTNoPlan, LOTNoCopro) " & _
"SELECT " & PROID & ", " & TPLID & ", " & CLIID & ", #" & Format(Date, "mm/dd/yyyy") & "#, #" & Format(LOTDatReserv, "mm/dd/yyyy") & "# , " & Nz(LOTTVA, 0) & ", '" & Nz(LOTRem, "") & "', " & Nz(LOTHT, 0) & ", " & Nz(LOTTTC, 0) & ", " & Nz(LOTHTConf, 0) & ", " & Nz(LOTTTCConf, 0) & ", " & Imm & ", '" & Nz(LOTNoPlan, "") & "', " & Nz(LOTNoCopro, 0) & ";" |
Partager