Connections database table - TaskDepender

Connections database table

From TaskDepender
Jump to: navigation, search
(Connect)
(Connect)
Line 96: Line 96:
 
   SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency,
 
   SELECT t.Id TaskId, d.Id DeliverableId, %d IsDependency,
 
   FROM SelectedTasks t, SelectedDeliverables d;
 
   FROM SelectedTasks t, SelectedDeliverables d;
</syntaxhighlight>
 
  
 
<syntaxhighlight lang="sql">
 
 
INSERT INTO Deliverables
 
INSERT INTO Deliverables
  SELECT d.Name, d.Description, d.Resource, d.X, d.Y, d.Width, d.Height, d.Link, d.Available,
+
()
  ConnectionId,
+
  ContainerId)
+
 
   FROM Deliverables d WHERE Id IN (SELECT Id FROM SelectedDeliverables)
 
   FROM Deliverables d WHERE Id IN (SELECT Id FROM SelectedDeliverables)
  

Revision as of 20:06, 22 November 2011

Personal tools