Connections database table - TaskDepender

Connections database table

From TaskDepender
Jump to: navigation, search
(Disconnect)
(Disconnect)
Line 113: Line 113:
  
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
DELETE FROM Connections WHERE TaskId=%d AND DeliverableId=%d
+
DELETE FROM Connections  
 +
WHERE Id IN
 +
 
 +
(
 +
 
 +
 
 +
 
 +
  SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency,
 +
  FROM SelectedTasks t, SelectedDeliverables d
 +
 
 +
)
 +
 
 +
 
 
</syntaxhighlight>
 
</syntaxhighlight>
  

Revision as of 20:44, 22 November 2011