Tornado API Library - V12.30.08

z.dbEditGridUpdateSQL Property

Define user specified Grid Update SQL.

Product Version

EP,Gold
[VisualBasic]
PublicPropertydbEditGridUpdateSQLAsString
[C#]
publicstringdbEditGridUpdateSQL{set;}

Property Value

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

KeywordDescription
FieldField 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.

QuickProp Keyword Abbreviation

eguq

See Also

z Class | Tornado Namespace | Special Topic - Edit | dbEditUpdateSQL