G
Guest
I have two tables with exact fields and datatypes. One table is linked and
the other is SQL back end. I run a history append or an update query and I
get the same append error msg. You know the one says datatypes or null etc.
Here is my SQL for the update query. Should be easy but driving me nuts. The
records move into the tables but for some reason the original 4 records stay
in the query. HELP!
UPDATE dbo_TblForm INNER JOIN DEV_dbo_TblForm ON dbo_TblForm.FormId =
DEV_dbo_TblForm.FormId SET DEV_dbo_TblForm.FormNumber =
dbo_TblForm.formnumber, DEV_dbo_TblForm.Description =
dbo_TblForm.description, DEV_dbo_TblForm.DigitalSignature =
dbo_TblForm.digitalsignature, DEV_dbo_TblForm.FileName =
dbo_TblForm.filename, DEV_dbo_TblForm.EffDate = dbo_TblForm.effdate,
DEV_dbo_TblForm.Attachment = dbo_TblForm.attachment,
DEV_dbo_TblForm.FormAvailable = dbo_TblForm.formavailable
WHERE (((DEV_dbo_TblForm.Description) Not Like [dbo_TblForm].[description]))
OR (((DEV_dbo_TblForm.FileName) Not Like [dbo_TblForm].[filename])) OR
(((DEV_dbo_TblForm.EffDate)<>[dbo_TblForm].[effdate])) OR
(((DEV_dbo_TblForm.DigitalSignature)<>[dbo_TblForm].[digitalsignature])) OR
(((DEV_dbo_TblForm.Attachment)<>[dbo_TblForm].[attachment])) OR
(((DEV_dbo_TblForm.FormAvailable)<>[dbo_TblForm].[formavailable]))
WITH OWNERACCESS OPTION;
the other is SQL back end. I run a history append or an update query and I
get the same append error msg. You know the one says datatypes or null etc.
Here is my SQL for the update query. Should be easy but driving me nuts. The
records move into the tables but for some reason the original 4 records stay
in the query. HELP!
UPDATE dbo_TblForm INNER JOIN DEV_dbo_TblForm ON dbo_TblForm.FormId =
DEV_dbo_TblForm.FormId SET DEV_dbo_TblForm.FormNumber =
dbo_TblForm.formnumber, DEV_dbo_TblForm.Description =
dbo_TblForm.description, DEV_dbo_TblForm.DigitalSignature =
dbo_TblForm.digitalsignature, DEV_dbo_TblForm.FileName =
dbo_TblForm.filename, DEV_dbo_TblForm.EffDate = dbo_TblForm.effdate,
DEV_dbo_TblForm.Attachment = dbo_TblForm.attachment,
DEV_dbo_TblForm.FormAvailable = dbo_TblForm.formavailable
WHERE (((DEV_dbo_TblForm.Description) Not Like [dbo_TblForm].[description]))
OR (((DEV_dbo_TblForm.FileName) Not Like [dbo_TblForm].[filename])) OR
(((DEV_dbo_TblForm.EffDate)<>[dbo_TblForm].[effdate])) OR
(((DEV_dbo_TblForm.DigitalSignature)<>[dbo_TblForm].[digitalsignature])) OR
(((DEV_dbo_TblForm.Attachment)<>[dbo_TblForm].[attachment])) OR
(((DEV_dbo_TblForm.FormAvailable)<>[dbo_TblForm].[formavailable]))
WITH OWNERACCESS OPTION;