Tornado API Library - V12.30.08

z.dbEditAddSQL Property

Define user specified Add SQL.

Product Version

EP,Gold
[VisualBasic]
PublicPropertydbEditAddSQLAsString
[C#]
publicstringdbEditAddSQL{set;}

Property Value

Obj.dbEditAddSQL = "Add SQL Statement with Macro"

Obj.dbEditAddSQL = "(|;)INSERT INTO Table (Fld1,Fld2,fld3,GUID) VALUES ('[[Val1]]',#[[Val2]]#,Val3,NewID())"

KeywordDescription
FldField is the fields of the dbSQL result and not the displayed order.
[[Val]]Values 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.

QuickProp Keyword Abbreviation

eaq

Remarks

NewID() must be used for GUID in EditAdd.

Example

See Also

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