Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 Tags
Subject: RE: Opening + Closing Balance
Thread ID: 345287 Message ID: 345303 # Views: 39 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 11:18:16 AM         
   


> >
> > A SCAN/ENDSCAN would be better in that case
> >
> >
lnClosing1=0
> > SCAN
> >    REPLACE open_1 with lnClosing1
> >    lnClosing1=lnClosing1+arrival_1 - sold_1
> >    REPLACE Closing_1 with lnClosing1
> > ENDSCAN
> > 

> >
> > Regards
> > Tushar
> > http://weblogs.foxite.com/tushar/
>
> Sir, Your codes removes closing1 with 0 in first line.
> The first line must be as it exists because it is opening balance of financial year starting.


Then put some unique field for every record.
What is the PK of this table?

-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

Opening + Closing Balance Posted by Tariq mehmood @ 5/22/2012 9:08:15 AM
RE: Opening + Closing Balance Posted by Borislav Borissov @ 5/22/2012 10:06:04 AM
RE: Opening + Closing Balance Posted by Tariq mehmood @ 5/22/2012 10:16:59 AM
RE: Opening + Closing Balance Posted by tushar @ 5/22/2012 10:30:42 AM
RE: Opening + Closing Balance Posted by Tariq mehmood @ 5/22/2012 10:39:58 AM
RE: Opening + Closing Balance Posted by Borislav Borissov @ 5/22/2012 11:18:16 AM
RE: Opening + Closing Balance Posted by Tariq mehmood @ 5/22/2012 11:24:33 AM
RE: Opening + Closing Balance Posted by Borislav Borissov @ 5/22/2012 11:40:32 AM