>>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 CHOICEADDED >>>>I 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 ) >>