List 6-15 List 6-13UpdateCustomerメソッドとList 6-14GetCustomerメソッドを用いて一部のフィールドの値だけを更新する
  1: Dim ID As Long, NAME As Variant, YOMIGANA As Variant
  2: Dim ZIP As Variant, ADDRESS As Variant
  3: Dim TELEPHONE As Variant, FAX As Variant
  4: Dim BILLDAY As Variant, MEMO As Variant
  5: Dim MADEUSER As Variant, MADEDATE As Variant
  6: Dim LASTUSER As Variant, LASTDATE As Variant
  7: Dim obj As Business.Customer
  8: 
  9: Set obj = CreateObject("Business.Customer")
 10: ' 現在の顧客番号が10番の情報を取得
 11: obj.GetCustomer 10, NAME, YOMIGANA, ZIP, ADDRESS, _
                     TELEPHONE, FAX, BILLDAY, MEMO, _
                     MADEUSER, MADEDATE, LASTUSER, LASTDATE
 12: ' 電話番号を変更
 13: TELEPHONE = "03-1234-5678"
 14: ' 更新する
 15: obj.UpdateCustomer 10, NAME, YOMIGANA, ZIP, ADDRESS, _
                        TELEPHONE, FAX, BILLDAY, MEMO