Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Christian Tabligan
  Where is Christian Tabligan?
 Bacolod City, Neg. Occ.
 Philippines
 Christian Tabligan
 To: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 Tags
Subject: RE: UDATE instead REPLACE
Thread ID: 289065 Message ID: 289179 # Views: 39 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 29, 2010 2:20:32 AM         
   


> Dear Christian
>
> Your both codes has syntax error.
>
> Please modify

Hard to test without vfp9...try my luck. :-)
CREATE CURSOR crsalp (vou_no n(4),type c(1),cr_amount n(4))
INSERT INTO crsalp values(1,'P',500)
INSERT INTO crsalp values(1,'D',100)
INSERT INTO crsalp values(2,'P',600)
INSERT INTO crsalp values(3,'P',800)
 
CREATE CURSOR cr_sum (vou_no n(4),dr_amount n(4))
INSERT INTO cr_sum values(1,0)
INSERT INTO cr_sum values(2,0)
INSERT INTO cr_sum values(3,0)

UPDATE cr_sum SET cr_sum.dr_amount = B.am1;
   FROM (select vou_no, sum(iif(type="P",cr_amount,0)) - sum(iif(type="D",dr_amount,0) as am1 FROM crsalp group by 1) B;
WHERE cr_sum.vou_no == B.vou_no


Best Regards,

CriZ (,")

"We are the foxes, we are the runners, we are the dancers, we create the dreams."

ENTIRE THREAD

UDATE instead REPLACE Posted by Tariq mehmood @ 12/28/2010 8:21:00 AM
RE: UDATE instead REPLACE Posted by Christian Tabligan @ 12/28/2010 8:55:55 AM
RE: UDATE instead REPLACE Posted by Tariq mehmood @ 12/28/2010 9:23:56 AM
RE: UDATE instead REPLACE Posted by Christian Tabligan @ 12/28/2010 10:08:55 AM
RE: UDATE instead REPLACE Posted by Tariq mehmood @ 12/28/2010 6:45:05 PM
RE: UDATE instead REPLACE Posted by Christian Tabligan @ 12/29/2010 2:20:32 AM
RE: UDATE instead REPLACE Posted by Tariq mehmood @ 12/29/2010 3:31:28 AM
RE: UDATE instead REPLACE Posted by Anders Altberg @ 12/28/2010 7:34:37 PM
RE: UDATE instead REPLACE Posted by Tariq mehmood @ 12/28/2010 7:58:04 PM
RE: UDATE instead REPLACE Posted by Anders Altberg @ 12/29/2010 5:32:54 PM
RE: UDATE instead REPLACE Posted by Anders Altberg @ 12/29/2010 5:59:54 PM