Update(Int32,String,String,String,DBString,String,DBString,DBString,DBString,DBString,DBString,DBString,Boolean,Boolean,DBString,DBString,DBString,DBString,DateTime) 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 lastEditAt input parameter.
'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, _
ByRef lastEditAt As Date _
)
'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 lastEditAt As Date
Cust.Update(sessionId, custId, custName, address1, address2, city, state, zip, country, phone, fax, email, customer, vendor, spare1, spare2, spare3, spare4, lastEditAt)
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,
ref DateTime lastEditAt
)
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.
- lastEditAt
Optional. Holds the datetime when this record was added or last updated, for optimistic concurrency control. If provided, the passed value must match the last_edit_at value in the record for the update to succeed.
Output. Holds the datetime value when the record was updated by this called method.