Recent content by jim_chance

I inserted the alias. Database is Progress. Is SQL updating to more then one table at a time not allowed in Progress? update pub.poheader as ph, pub.podetail as pd, pub.porel as pd set openorder = 0, openline = 0, openrelease = 0 where ph.PONum = pd.PONum and pd.PONum = pr.PONum and...

I'm trying to update 3 fields in 2 tables based on the following, but I'm getting a syntax error. Error: Syntax error (7587) (State:37000, Native Code: FFFFB1DD) What's wrong with this statement? update pub.poheader, pub.podetail, pub.porel set openorder = 0, openline = 0, openrelease = 0...