1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| sSql = [
INSERT INTO T_Activite (ID_DetailPrestation, Quantite, ID_LotActivite, DateHeure_Debut, DateHeure_Fin, ID_Marchandise, ID_Ressource, Prix_Unitaire, Observation)
VALUES (%1, %2, %3, %4, %5, %6, %7, %8, %9)
]
sSql = ChaîneConstruit(sSql, pnIdDetailPrestation, ...
txtQuantite, ...
pnIdLotActivite, ...
cConnexionSQLServer::FormatDate(txtDateDebut), ...
cConnexionSQLServer::FormatDate(txtDateFin), ...
cboMarchandise, ...
cboRessource, ...
0, ...
cConnexionSQLServer::FormatChaine(txtObservations))
SI oReq:Executer(sSql) ALORS
znRetour = oReq:LastId()
FIN |
Partager