SELECT * FROM PresGame WHERE PresGameID=;OUTPUT NIL SELECT PollEnd FROM Race WHERE RaceID=;OUTPUT NIL SELECT 8-dayofweek('-09-06') LaborDayD;OUTPUT NIL Our Campaigns - US Presidential Game - <VAR CurDate,Safe> SELECT 9-dayofweek('-11-06') ElectionDay;OUTPUT NIL SELECT (TO_DAYS('-11-') - TO_DAYS()) DaysLeft;OUTPUT NIL
  US Presidential Game - // - ED 11// - days
SELECT SecLink FROM Security WHERE SecLink=23 AND UserLink=;OUTPUT NIL SELECT *,dayofweek('-08-31') LaborDay FROM Race WHERE RaceID=;OUTPUT NIL INSERT INTO PresGame (Title,CurDate,CreatedBy,CreatedDate,RaceLink,Handicap,RandomSeed,MaxPoints,IncumbentPartyLink) values (,'-09-',,Now(),,,,,);FINISH SELECT BuildPoints,PartyLink FROM PresGameCandidate WHERE PresGameCandidateID=;OUTPUT NIL INSERT INTO PresGameCandidateLink (PresGameLink,PresCandidateLink,PartyLink,UserLink,Approved) VALUES (,,,,'Y');FINISH UPDATE PresGame SET NumCandidates=NumCandidates+1 WHERE PresGameID=;FINISH SELECT PresGameCandidateID,FirstName,LastName,BirthDate,BuildPoints,Abbr,Color FROM PresGameCandidate as c,Party WHERE c.FirstBy= AND PartyID=PartyLink ORDER BY c.FirstEnter DESC;>SELECT COUNT(*) InGames FROM PresGameCandidateLink,PresGame WHERE (PresCandidateLink = OR (VPCandidateLink = ) AND PresGameID=PresGameLink AND WinnerLink=0;OUTPUT NILOUTPUT
Choose Presidential Game Candidate
PtyNameBornBuild PointsModify
You have not yet created any Presidental Game Candidates
[Edit Candidate] In Games
SELECT * FROM Race WHERE RaceID=;OUTPUT NIL
CREATE NEW PRESIDENTIAL GAME
Based On Presidential Race
Title of Game
Incumbent
Player Creation Rules -
Select Candidate

9/23/2008
$3,456,235

Location: TX - Stamina: 67%