Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tariq Mehmood
  Where is Tariq Mehmood?
 BAHAWALPUR
 Pakistan
 Tariq Mehmood
 To: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 Tags
Subject: RE: Opening + Closing Balance
Thread ID: 345287 Message ID: 345299 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 10:39:58 AM         
   


> >
> > Dear Sir,
> >
> > I do not want to use this line
> >
> >
> > GROUP BY Stock.Date;
> > 

> >
> > If a date appears more than one time then it must appear more than one time.
> >
> > Suppose I have following codes
> >
> >
> > INSERT INTO stock VALUES ({^2012-07-01},0,0,0,0,0,0,15,30)
> > INSERT INTO stock VALUES ({^2012-09-09},0,0,10,0,0,0,0,0)
> > INSERT INTO stock VALUES ({^2012-09-09},0,0,15,0,0,0,0,0)
> > INSERT INTO stock VALUES ({^2012-09-10},0,0,10,0,0,0,0,0)
> > INSERT INTO stock VALUES ({^2012-09-11},0,0,0,15,0,0,0,0)
> > INSERT INTO stock VALUES ({^2012-09-21},0,0,0,0,30,60,0,0)
> > 

> >
> > Date ({^2012-09-09} is more than one time. So it must appear as it.
> > I do not want to Sum QTY in date.
> >
> >
> > Please help again
>
> 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.

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