1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35
|
Sub PHOTO_INSERT(ByVal VVST_BDDCB As String, ByVal VVST_CUSER As String)
R9 = "INSERT"
R9 = R9 & " INTO UCB.T_CB_Photo"
R9 = R9 & " (T_CB_Photo.IDENTIFIANT"
R9 = R9 & ",T_CB_Photo.NUM_DOSSIER"
R9 = R9 & ",T_CB_Photo.NOM_PHOTO"
R9 = R9 & ",T_CB_Photo.TYPE_MIME"
R9 = R9 & ",T_CB_Photo.FICHIER"
R9 = R9 & ",T_CB_Photo.DATE_CREATION)"
R9 = R9 & " VALUES ('" & PHOTO_ID & "'"
R9 = R9 & ",'" & PHOTO_NUM_DOSSIER & "'"
R9 = R9 & ",'" & PHOTO_NOM_PHOTO & "'"
R9 = R9 & ",'" & PHOTO_TYPE_MIME & "'"
R9 = R9 & "," & PHOTO_FICHIER &
R9 = R9 & ",'" & PHOTO_DATE_CREATION & "')"
Try
VMUG999.ADO_EXECUTE_SCALAR(VVST_BDDCB, VVST_CUSER, R9, VMUG999.VGST_LIBER)
If VMUG999.VGST_LIBER <> "" Then
VGST_NOERR = "I07901"
VMUG999.VGST_LIBER = R9 & VGST_CRLFX & VGST_CRLFX & VMUG999.VGST_LIBER
VMUG999.VGNN_ARRET = 1
TRAIT_ERREUR_ADO(VGST_NOERR)
End
End If
Catch VGNN_EXCEP As Exception
VGST_NOERR = "I07901"
VMUG999.VGST_LIBER = R9 & VGST_CRLFX & VGST_CRLFX & VGNN_EXCEP.ToString
VMUG999.VGNN_ARRET = 1
TRAIT_ERREUR_ADO(VGST_NOERR)
End
End Try
End Sub |
Partager