Tornado API Library - V12.30.08

z.dbEditUpdateSQL Property

Define user specified Update SQL.

Product Version

EP,Gold
[VisualBasic]
PublicPropertydbEditUpdateSQLAsString
[C#]
publicstringdbEditUpdateSQL{set;}

Property Value

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

KeywordDescription
FieldField is the fields of the dbSQL result 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.

QuickProp Keyword Abbreviation

euq

Remarks

Example

See Also

z Class | Tornado Namespace | dbEditGridUpdateSQL | dbEditAddSQL | Special Topic - Edit