Re: This SQL didn't update just one record but ALL records....OOPS!!!!!

2020-10-26 Thread Peter Cushing
Just curious, what happens if you try this?                     UPDATE carriers_to_process ;                       SET cSession = this.cSession ;                       FROM carriers_to_process p1,curWorkingGroup g1 ;                       where g1.iid = p1.iid That's using the old syntax inne

RE: This SQL didn't update just one record but ALL records....OOPS!!!!!

2020-10-26 Thread Richard Kaye
I read too fast. Ignore me. -- rk -Original Message- From: ProfoxTech On Behalf Of Richard Kaye Sent: Monday, October 26, 2020 12:12 PM To: profoxt...@leafe.com Subject: RE: This SQL didn't update just one record but ALL records....OOPS! You still need a WHERE clause... -

RE: This SQL didn't update just one record but ALL records....OOPS!!!!!

2020-10-26 Thread Richard Kaye
You still need a WHERE clause... -- rk -Original Message- From: ProfoxTech On Behalf Of MB Software Solutions, LLC Sent: Monday, October 26, 2020 12:06 PM To: profoxt...@leafe.com Subject: This SQL didn't update just one record but ALL recordsOOPS! VFP9SP2 using DBC tables. T