1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| sdRequeSQL, sdInsertSQL est une Source de Données
HPrépareRequêteSQL(sdInsertSQL, FusionParTable.gstrBaseFinale:sNomCrp, hRequêteSansCorrection, "INSERT INTO t_vaccination (nIdVaccination, nIdVaccin, nIdVacProtocole, nIdPatient, nIdUtilisateur, sDateInjection, nNumInjection, sNumLot, nRappel, sLibelle, sAction, sDH_REPLIC) SELECT 251,41,4,53,1,'20030528','0','W5770-2',0,'DTP - REVAXIS','A 20130521170623','2013-05-21 17:06:23' FROM t_vaccination WHERE NOT EXISTS (SELECT nIdVaccin, nIdVacProtocole, nIdPatient, nIdUtilisateur FROM t_vaccination WHERE nIdVaccin =:IdVaccin and nIdVacProtocole =:IdVacProtocole and nIdPatient =:IdPatient and nIdUtilisateur =:IdUser ) LIMIT 1")
TANTQUE
.....
bResult = HExécuteRequêteSQL(sdRequeSQL, FusionParTable.gstrBaseFinale:sNomCrp, "select Max(nIdVaccination) as compteur from t_vaccination")
sdInsertSQL.IdVaccin = Val(sIdVaccin)
sdInsertSQL.IdVacProtocole = Val(sIdVacProtocole)
sdInsertSQL.IdPatient = Val(sIdPatient)
sdInsertSQL.IdUser = Val(sIdUser)
//bResult = HExécuteRequêteSQL(sdInsertSQL, FusionParTable.gstrBaseFinale:sNomCrp, sInsertSQL)
bResult = HExécuteRequêteSQL(sdInsertSQL)
.....
FIN |
Partager