Deliverables database table - TaskDepender

Deliverables database table

From TaskDepender
Jump to: navigation, search
(Actions)
(Update)
Line 87: Line 87:
 
(Name,Description, Resource, X, Y,  Width, Height, Link, Available, ConnectionId, ContainerId)
 
(Name,Description, Resource, X, Y,  Width, Height, Link, Available, ConnectionId, ContainerId)
 
VALUES (%s, %s, %s, %d, %d, %d, %d, %s, %d, 0, (SELECT Val FROM StateVariables WHERE Name='CurrentContainerId'))
 
VALUES (%s, %s, %s, %d, %d, %d, %d, %s, %d, 0, (SELECT Val FROM StateVariables WHERE Name='CurrentContainerId'))
</syntaxhighlight>
 
 
=== Update ===
 
 
<syntaxhighlight lang="sql">
 
UPDATE Deliverables SET
 
  Name=%s,
 
  Description=%s,
 
  Resource=%s,
 
  X=%d,
 
  Y=%d,
 
  Link=%s,
 
  Width=%d,
 
  Height=%d
 
  Available=%d
 
WHERE Id IN (SELECT Id FROM SelectedDeliverables LIMIT 1)
 
 
</syntaxhighlight>
 
</syntaxhighlight>
  

Revision as of 20:15, 29 November 2011

Personal tools