dbEditAddSQL Property

Define user specified Add SQL.

EP,Gold

[Visual Basic]
Public Property dbEditAddSQL As String

[C#]
public string dbEditAddSQL {set;}

Obj.dbEditAddSQL = "Add SQL Statement with Macro"

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

Keyword	Description
Fld	Field 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.

eaq

NewID() must be used for GUID in EditAdd.

X.dbEditAddSQL="(|;)INSERT INTO FLname (ID, LastName, FirstName) VALUES ('[[0]]', '[[2]]', '[[3]]'); INSERT INTO Address (ID, Addr) VALUES ('[[0]]', '[[1]]')"

z.dbEditAddSQL Property