DELETE FROM UserNewItems WHERE UserLink= AND ItemType='Issue' AND ItemLink=;FINISHINSERT INTO UserNewItems (UserLink,ItemType,ItemLink,ReadDate) VALUES (,'Issue',,Now());FINISHSELECT SecLink FROM Security WHERE SecLink=16 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=17 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=18 AND UserLink=;OUTPUT NILDELETE FROM Discussion WHERE AttachTo='Issue' AND AttachID=;FINISHDELETE FROM Book WHERE AttachTo='Issue' AND AttachID=;FINISHDELETE FROM InfoLink WHERE AttachTo='Issue' AND AttachID=;FINISHDELETE FROM NewsAttach WHERE AttachType='News' AND AttachID=;FINISHUPDATE Issue SET ParentIssue= WHERE ParentIssue=;FINISHIssue Deleted. DELETE FROM Issue WHERE IssueID=;FINISHIssue Deleted. Picked Up UPDATE Issue SET ParentIssue=-1 WHERE IssueID=;FINISHSELECT IssueID TIID FROM Issue WHERE ParentIssue=;OUTPUTDropped UPDATE Issue SET ParentIssue= WHERE IssueID=;FINISHSELECT IssueID TIID FROM Issue WHERE ParentIssue=-1;OUTPUTSELECT * FROM Issue WHERE IssueID=;OUTPUT NILSELECT Nym FROM User WHERE UserID=;OUTPUT NILSELECT Nym CNym FROM User WHERE UserID=;OUTPUT NIL
>
Parent Issue
SELECT IssueID TIID,Name CName,MemberOnly CMO,Silly CSil FROM Issue WHERE IssueID= AND Silly!='Y' AND MemberOnly!='Y';OUTPUTSELECT IssueID TIID,Name CName,MemberOnly CMO,Silly CSil FROM Issue WHERE ParentIssue= AND Silly!='Y' AND MemberOnly!='Y' ORDER BY Priority,Name;
Sub-Issues
OUTPUTSELECT IssueID TIID,Name CName,MemberOnly CMO,Silly CSil FROM Issue WHERE ParentIssue=-1 ORDER BY Category,Name;
PICKED UP
OUTPUT
ne ''>
SELECT SecLink FROM Security WHERE SecLink=43 AND UserLink=;OUTPUT NILSELECT SecLink FROM Security WHERE SecLink=45 AND UserLink=;OUTPUT NIL