dbEditGridUpdateSQL Property

Define user specified Grid Update SQL.

EP,Gold

[Visual Basic]
Public Property dbEditGridUpdateSQL As String

[C#]
public string dbEditGridUpdateSQL {set;}

Obj.dbEditGridUpdateSQL = "(|;)UPDATE Field(s) SET Field(s) = [[New value]] WHERE Field1 = {{Criteria value}} AND Field2 = {{Criteria value1}}"

Keyword	Description
Field	Field is the field ordinals of the dbSQL and not the displayed order.
[[New value]]	[[New Value]] are to be filled with the User input(s). The [[..]] wrappers are non-negotiable. User is responsible for the correct wrappers for the different data types.
{{Criteria value}}	{{Criteria value}} is the existing value of the record that governs which field to update. The {{..}} wrappers are non-negotiable. User is responsible for the correct wrappers for the different data types.

eguq

z.dbEditGridUpdateSQL Property