SELECT ID, AgentID, ProjectID, FirstName, LastName,
Email, BlueTotal, RedTotal, GreenTotal, YellowTotal,
PrimaryColor, ColorAssigned, GroupAssigned
FROM participants
WHERE ActionFlag = 1
INSERT INTO teams
(ID, AgentID, TeamName, TeamCode,
DateCreated, ContactFirstName, ContactLastName,
ContactEmail, ContactPhoneNumber, TeamType,
NotifyAOnEval, NotifyCOnEval,
MemberCount
)
VALUES ('#Tmp#', '#Client.AgentID#', '#Client.TeamCreate_TeamName#', '#Client.TeamCreate_TeamCode#',
#CreateODBCDate(Now())#, '#Client.TeamCreate_ContactFirstName#', '#Client.TeamCreate_ContactLastName#',
'#Client.TeamCreate.ContactEmail#', '#Client.TeamCreate_ContactPhoneNumber#', '#Client.TeamCreate_TeamType#',
#Client.TeamCreate_NotifyAOnEval#, #Client.TeamCreate_NotifyCOnEval#,
#GetTeam.RecordCount#
)
INSERT INTO teammembers
(ID, AgentID, TeamID, TeamCode, ParticipantID,
FirstName, LastName, Email,
BlueTotal, RedTotal, GreenTotal, YellowTotal,
PrimaryColor, ColorAssigned, GroupAssigned,
DateCreated
)
VALUES('#CreateUUID()#', '#Client.AgentID#', '#Tmp#', '#Client.TeamCreate_TeamCode#', '#GetTeam.ID#',
'#GetTeam.FirstName#', '#GetTeam.LastName#', '#GetTeam.Email#',
#GetTeam.BlueTotal#, #GetTeam.RedTotal#, #GetTeam.GreenTotal#, #GetTeam.YellowTotal#,
'#GetTeam.PrimaryColor#', '#GetTeam.ColorAssigned#', '#GetTeam.GroupAssigned#',
#CreateODBCDate(Now())#
)
UPDATE participants
SET ActionFlag = 0
temp = DeleteClientVariable("Client.TeamCreate_TeamName");
temp = DeleteClientVariable("Client.TeamCreate_ContactFirstName");
temp = DeleteClientVariable("Client.TeamCreate_ContactLastName");
temp = DeleteClientVariable("Client.TeamCreate_ContactPhoneNumber");
temp = DeleteClientVariable("Client.TeamCreate.ContactEmail");
temp = DeleteClientVariable("Client.TeamCreate_TeamType");
temp = DeleteClientVariable("Client.TeamCreate.NotifyCOnAssess");
temp = DeleteClientVariable("Client.TeamCreate.NotifyAOnAssess");
temp = DeleteClientVariable("Client.TeamProjectID");
temp = DeleteClientVariable("Client.TeamAction");