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
 Tags
Subject: Opening + Closing Balance
Thread ID: 345287 Message ID: 345287 # Views: 58 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Tuesday, May 22, 2012 9:08:15 AM         
   


Dear Experts

I have following data


CREATE CURSOR stock(date d(8),open_1 n(4),open_2 n(4),arrival_1 n(4),arrival_2 n(4),sold_1 n(4),sold_2 n(4),closing_1 n(4),closing_2 n(4))

INSERT INTO stock value({^2012-07-01},0,0,0,0,0,0,15,30)
INSERT INTO stock value({^2012-09-09},0,0,10,0,0,0,0,0)
INSERT INTO stock value({^2012-09-10},0,0,10,0,0,0,0,0)
INSERT INTO stock value({^2012-09-11},0,0,0,15,0,0,0,0)
INSERT INTO stock value({^2012-09-21},0,0,0,0,30,60,0,0)



Please help

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