SQL Error

[Steve Kuchta]

Hi everybody,

I am hoping somebody will have an answer for me. I have been getting the following error when trying to copy the contents of one field to the contents of another field. Both fields are in different tables. *************************************************
Error: Syntax error (7587) (State:37000, Native Code: FFFFB1DD)
*************************************************

The following are the sql statements themselves:
*************************************************
select PUB.JobHead.ProdCode, PUB.Part.ProdCode
from PUB.JobHead, PUB.Part
where PUB.JobHead.PartNum = PUB.Part.PartNum and PUB.JobHead.ProdCode <> PUB.Part.ProdCode
go

update PUB.JobHead
from PUB.JobHead, PUB.Part
set PUB.JobHead.ProdCode = PUB.Part.ProdCode
where PUB.JobHead.PartNum = PUB.Part.PartNum and PUB.JobHead.ProdCode <> PUB.Part.ProdCode
go
*************************************************

The select statement gives me exactly what I want but the error comes when I try to do the update. We are running Progress91D. I am thinking this code should work but I feel the error is coming in with the joining of the two tables. Can anyone out there help me?

Thank you very much,

Steve Kuchta


Hi, I am adding this because I have not made any headway with this issue. I really hope somebody out there can help me.

Thank you very much,

Steve Kuchta