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
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...
-
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 records....OOPS!
VFP9SP2 using DBC t
VFP9SP2 using DBC tables.
The curWorkingGroup cursor had just ONE record in it. The
Carriers_To_Process table (PK = IID field) has tens of thousands. The
idea is that I'm just processing small sections at a time from
Carriers_To_Process. Rather than update the one or two records in the
curW
4 matches
Mail list logo
