R
rob muzzy
I have a sql view that has the following code from our existing ERP.
SELECT "WORKORDER_TYPE",
"WORKORDER_BASE_ID",
"WORKORDER_LOT_ID",
"WORKORDER_SPLIT_ID",
"WORKORDER_SUB_ID",
"OPERATION_SEQ_NO",
"PIECE_NO",
"TYPE",
CASE (UNICODE(CAST(CAST("BITS" AS VARBINARY(4000)) AS NVARCHAR
(4000)))
- ASCII(LEFT(CAST("BITS" AS VARBINARY(4000)),
1))) WHEN 0 THEN CAST(CAST("BITS" AS VARBINARY(8000)) AS NVARCHAR
(4000)) ELSE CAST(CAST("BITS" AS VARBINARY(8000)) AS VARCHAR(8000))
END AS "BITS",
"BITS_LENGTH"
FROM REQUIREMENT_BINARY
WHERE "TYPE" = 'D'
I am trying to write back to the code via an access linked table and
I
am getting an error. can anyone help me fix the view so access can
write back to it
the primary keys are workorder type through type
thanks in advance
SELECT "WORKORDER_TYPE",
"WORKORDER_BASE_ID",
"WORKORDER_LOT_ID",
"WORKORDER_SPLIT_ID",
"WORKORDER_SUB_ID",
"OPERATION_SEQ_NO",
"PIECE_NO",
"TYPE",
CASE (UNICODE(CAST(CAST("BITS" AS VARBINARY(4000)) AS NVARCHAR
(4000)))
- ASCII(LEFT(CAST("BITS" AS VARBINARY(4000)),
1))) WHEN 0 THEN CAST(CAST("BITS" AS VARBINARY(8000)) AS NVARCHAR
(4000)) ELSE CAST(CAST("BITS" AS VARBINARY(8000)) AS VARCHAR(8000))
END AS "BITS",
"BITS_LENGTH"
FROM REQUIREMENT_BINARY
WHERE "TYPE" = 'D'
I am trying to write back to the code via an access linked table and
I
am getting an error. can anyone help me fix the view so access can
write back to it
the primary keys are workorder type through type
thanks in advance