>APPEND BLANK IN csrProjSessions >REPLACE csrProjSessions.ProjSessionsID WITH -1 >REPLACE csrProjSessions.GroupID WITH this.Parent.Parent.nSelGroupID >REPLACE csrProjSessions.VisitID WITH lnSelVisitID >REPLACE csrProjSessions.ProjSessionsName WITH TRIM(this.Parent.Parent.cSelGroupName) + '-' + TRIM(lcSelVisitName) >REPLACE csrProjSessions.ChoiceModifiedCol WITH CHOICEADDED >>
APPEND BLANK IN csrProjSessions REPLACE IN csrProjSessions ; csrProjSessions.ProjSessionsID WITH -1, ; csrProjSessions.GroupID WITH this.Parent.Parent.nSelGroupID ; csrProjSessions.VisitID WITH lnSelVisitID ; csrProjSessions.ProjSessionsName WITH TRIM(this.Parent.Parent.cSelGroupName) + '-' + TRIM(lcSelVisitName) ; csrProjSessions.ChoiceModifiedCol WITH CHOICEADDEDI would also recomend to use INSERT INTO
INSERT INTO csrProjSessions ; (ProjSessions, GroupID, VisitID, ProjSessionsName, ChoiceModifiedCol) ; VALUES ( -1, this.Parent.Parent.nSelGroupID, lnSelVisitID, ; TRIM(this.Parent.Parent.cSelGroupName) + '-' + TRIM(lcSelVisitName), ; CHOICEADDED )