Files
pdm/helpers/queries/INSERT_VV50_Copy.sql

10 lines
561 B
Transact-SQL

-- Insert a VariableValue row that mirrors an existing VV-57 row but with
-- VariableID = 50 (used by copy_57_to_50 task).
-- Parameter order MUST match build_params() in copy_57_to_50:
-- VariableID, DocumentID, ProjectID, RevisionNo, ConfigurationID,
-- ValueText, ValueInt, ValueFloat, ValueDate, ValueCache, IsLongText
INSERT INTO [Drilling_Test].[dbo].[VariableValue]
(VariableID, DocumentID, ProjectID, RevisionNo, ConfigurationID,
ValueText, ValueInt, ValueFloat, ValueDate, ValueCache, IsLongText)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);