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 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
| Private Function saveData() As Boolean
Dim orsSaveData As ADODB.Recordset
Dim strsqlSaveData As String
On Error GoTo saveData_Error
'on part du principe que tout c'est bien déroulé
saveData = True
strsqlSaveData = "select * from TableCustomer "
Set orsSaveData = New ADODB.Recordset
With orsSaveData
.Open strsqlSaveData, CurrentProject.Connection, adOpenDynamic, adLockOptimistic, adCmdText
If m_intBoutonPressed = enu_BtnPressed_Ajout Then .AddNew
!ID_SAP_FL = (TxtFCustomerEditDetailSapFl)
!STATUS = NullToEmptyString(TxtFCustomerEditDetailStatus)
!CONTACT = NullToEmptyString(TxtFCustomerEditDetailContact)
!Tel = NullToEmptyString(TxtFCustomerEditDetailTel)
!FAX = NullToEmptyString(TxtFCustomerEditDetailFax)
!IN_SERVICE_DATE = iif(isnull(TxtFCustomerEditDetailInSDate),Null,TxtFCustomerEditDetailInSDate)
!OUT_OF_SERVICE_DATE = iif(isnull(TxtFCustomerEditDetailOoSDate),Null,TxtFCustomerEditDetailOoSDate)
!CONTRACT = NullToEmptyString(TxtFCustomerEditDetailContract)
!CONTRACT_START = iif(isnull(TxtFCustomerEditDetailContractStart),Null,TxtFCustomerEditDetailContractStart)
!CONTRACT_END = iif(isnull(TxtFCustomerEditDetailcontractEnd),Null,TxtFCustomerEditDetailcontractEnd)
!COLLOCATION = NullToEmptyCheckBox(ChkFCustomerEditDetailCollo)
!COLLO_TEXT = NullToEmptyString(TxtFCustomerEditDetailColloT)
!TERRESTRIAL = NullToEmptyCheckBox(ChkFCustomerEditDetailTerre)
!IP_BACKBONE = NullToEmptyCheckBox(ChkFCustomerEditDetailBackbone)
!OUR_SPACE = NullToEmptyCheckBox(ChkFCustomerEditDetailOurSpace)
!COMPANY = NullToEmptyString(TxtFCustomerEditDetailCompany)
!MR = TxtFCustomerEditDetailMR
!CURRENCY = NullToEmptyString(TxtFCustomerEditDetailCurrency)
.Update
.Close
End With
Set orsSaveData = Nothing
Exit Function 'oRs
saveData_Error:
'le sauvetage c'est mal déroulée
saveData = False
MsgBox Replace(g_cstrErrMesg, "@", "saveData") & vbCrLf & Err.Description, _
vbCritical, "Erreur dans la fenêtre F_CustomerEditDetails"
End Function 'saveData |
Partager