C
ChrisP
I have a table which has 5 primary keys. I am having a
problem when I try to run a DELETE statement.
3 of the Primary keys are a Date/Time type.
The error message is a Data Type Mismatch error.
I know it has to do with the 3 keys that are Date/Time
types.
Here is my SQL:
DELETE FROM Case_Issue_Tech_t WHERE [Case#] = '123' AND
[Issue#] = '123' AND TechID = '123' AND [Date] = 'a date'
AND [Time_Start] = 'a start time' AND [Time_End] = 'an
end time'
Thanks for your help head of time,
Chris
problem when I try to run a DELETE statement.
3 of the Primary keys are a Date/Time type.
The error message is a Data Type Mismatch error.
I know it has to do with the 3 keys that are Date/Time
types.
Here is my SQL:
DELETE FROM Case_Issue_Tech_t WHERE [Case#] = '123' AND
[Issue#] = '123' AND TechID = '123' AND [Date] = 'a date'
AND [Time_Start] = 'a start time' AND [Time_End] = 'an
end time'
Thanks for your help head of time,
Chris