UpdateSpecific(Int32,String,String,String,DBString,String,DBString,DBString,DBString,DBString,DBString,DBString,Nullable<Boolean>,Nullable<Boolean>,DBString,DBString,DBString,DBString,DBString,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The UpdateSpecific() method updates selected 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 UpdateSpecific( _
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 Nullable(Of Boolean), _
ByVal vendor As Nullable(Of 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 Nullable(Of Boolean)
Dim vendor As Nullable(Of 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.UpdateSpecific(sessionId, custId, custName, address1, address2, city, state, zip, country, phone, fax, email, customer, vendor, spare1, spare2, spare3, spare4, lastEditComment, modId)
public static void UpdateSpecific(
int sessionId,
string custId,
string custName,
string address1,
DBString address2,
string city,
DBString state,
DBString zip,
DBString country,
DBString phone,
DBString fax,
DBString email,
Nullable<bool> customer,
Nullable<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
- Optional. Holds the name of the customer or vendor.
- address1
- Optional. Holds the street address of the customer or vendor.
- address2
- Optional. Holds an extra line for a street address.
- city
- Optional. Holds the city portion of the address.
- state
- Optional. Holds the state portion of the address.
- zip
- Optional. Holds the ZIP code portion of the address.
- country
- Optional. Holds the country portion of the address.
- phone
- Optional. Holds the phone number of the customer or vendor.
- fax
- Optional. Holds the fax number of the customer or vendor.
- Optional. Holds the email address of the customer or vendor.
- customer
Optional. 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
- Optional. Holds a flag that, if true, indicates that this is a vendor.
- spare1
- Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional. Holds the contents of the user-defined spare4 field.
- lastEditComment
- Optional. Holds comments that describes why this record is being added.
- modId
Required. Holds the modification ID assigned the last time this record was added or updated, for optimistic concurrency control. The passed value must match the record's modId value for the update to succeed.
Output. Holds the new modification ID to identify this update of this record.
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.