Code: Select all
put "INSERT INTO Baby (EventID) values(:1)" into tCmd
revExecuteSQL gconnectID, tCmd, "tEventID" -- creates a new empty record with mothers EventID
Code: Select all
put "INSERT INTO Baby (EventID, Baby) values(:1,:2)" into tCmd
revExecuteSQL gconnectID, tCmd, "tEventID, tBaby" -- creates a new empty record with mothers EventID and Baby-A,B,C,etc
PS I am aware that placeholders (:1, :2) cannot refer to column names, and in this case they don't. These are just variables with single values assigned to them.
Thanks!!