Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: joe Degorio
  Where is joe Degorio?
 Tacloban City
 Philippines
 joe Degorio
 To: mike castillo
  Where is mike castillo?
 Joo Seng Road, Singapore
 Philippines
 mike castillo
 Tags
Subject: RE: help with SQL command
Thread ID: 209381 Message ID: 209401 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Sunday, December 28, 2008 12:42:08 PM         
   


> > Hello Everyone,
> > Can anybody share an idea\code to process with the following data sample...
> >
> >
> > I would like to subtract the total Quantities of the same item product ID (e.g expiry_date.itemprod_id=4800289820865 which has the total of 5 qty let say I want to subtract 4) but must start deducting from the priority date 08/12/28. The expected result should be.....
> > ****Itemprod_id************qty*******expiry*******lot_no
> > 4800289820865***********1********09/01/10*****WING1000
> >
> > thanks in advance,
> > joe
>
> Hi Joe,
>
> I think you cannot do a direct SQL Update Command, but I think you can do a loop in updating this type of First IN - First OUT approach.
>
> Kind regards,
> Mike

Hi Mike,
Thanks for the immediate reply...and for the idea..BTW, thanks for helping with my problem regarding the report, it solved my problem and forgot to rate it :)

regards,
joe

ENTIRE THREAD

help with SQL command Posted by joe Degorio @ 12/28/2008 8:06:53 AM
RE: help with SQL command Posted by mike castillo @ 12/28/2008 8:35:35 AM
RE: help with SQL command Posted by joe Degorio @ 12/28/2008 12:42:08 PM
RE: help with SQL command Posted by mike castillo @ 12/29/2008 2:22:41 AM
RE: help with SQL command Posted by tushar @ 12/28/2008 10:13:42 AM
RE: help with SQL command Posted by joe Degorio @ 12/28/2008 12:44:53 PM
RE: help with SQL command Posted by Anders Altberg @ 12/28/2008 8:39:35 PM
RE: help with SQL command Posted by joe Degorio @ 12/29/2008 10:50:19 AM
RE: help with SQL command Posted by Jun Tangunan @ 12/29/2008 5:25:47 AM