Update(Int32,String,String,String,DBString,String,DBString,DBString,DBString,DBString,DBString,DBString,Boolean,Boolean,DBString,DBString,DBString,DBString,DBString,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The Update() method updates all columns of the specified customer or vendor record in the Cust table.
This overload of the method includes the lastEditComment and modId input parameters.
'Declaration
Public Overloads Shared Sub Update( _
ByVal sessionId As Integer, _
ByVal custId As String, _
ByVal custName As String, _
ByVal address1 As String, _
ByVal address2 As DBString, _
ByVal city As String, _
ByVal state As DBString, _
ByVal zip As DBString, _
ByVal country As DBString, _
ByVal phone As DBString, _
ByVal fax As DBString, _
ByVal email As DBString, _
ByVal customer As Boolean, _
ByVal vendor As Boolean, _
ByVal spare1 As DBString, _
ByVal spare2 As DBString, _
ByVal spare3 As DBString, _
ByVal spare4 As DBString, _
ByVal lastEditComment As DBString, _
ByRef modId As String _
)
'Usage
Dim sessionId As Integer
Dim custId As String
Dim custName As String
Dim address1 As String
Dim address2 As DBString
Dim city As String
Dim state As DBString
Dim zip As DBString
Dim country As DBString
Dim phone As DBString
Dim fax As DBString
Dim email As DBString
Dim customer As Boolean
Dim vendor As Boolean
Dim spare1 As DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim modId As String
Cust.Update(sessionId, custId, custName, address1, address2, city, state, zip, country, phone, fax, email, customer, vendor, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void Update(
int sessionId,
string custId,
string custName,
string address1,
DBString address2,
string city,
DBString state,
DBString zip,
DBString country,
DBString phone,
DBString fax,
DBString email,
bool customer,
bool vendor,
DBString spare1,
DBString spare2,
DBString spare3,
DBString spare4,
DBString lastEditComment,
ref string modId
)
Parameters
- sessionId
- Required. Holds the session ID and thus the user who is making this method call.
- custId
- Required. Holds the customer or vendor ID.
- custName
- Required. Holds the name of the customer or vendor.
- address1
- Required. Holds the street address of the customer or vendor.
- address2
- Required. Holds an extra line for a street address.
- city
- Required. Holds the city portion of the address.
- state
- Required. Holds the state portion of the address.
- zip
- Required. Holds the ZIP code portion of the address.
- country
- Required. Holds the country portion of the address.
- phone
- Required. Holds the phone number of the customer or vendor.
- fax
- Required. Holds the fax number of the customer or vendor.
- Required. Holds the email address of the customer or vendor.
- customer
Required. Holds a flag that, if true, indicates that this is a customer.
If you both buy from and sell to this firm, then both the customer and vendor flags can be true to indicate this.
- vendor
- Required. Holds a flag that, if true, indicates that this is a vendor.
- spare1
- Required. Holds the contents of the user-defined spare1 field.
- spare2
- Required. Holds the contents of the user-defined spare2 field.
- spare3
- Required. Holds the contents of the user-defined spare3 field.
- spare4
- Required. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Required. Holds comments that describes why this record is being added.
- modId
Required. Holds the modification ID that was assigned when this record was added or last updated, for optimistic concurrency control. The passed value must match the mod_id value in the record for the update to succeed.
Output. Holds the new modification ID to identify this update of this record.