Re: Vfp6 to Vfp9 Sql Group By

2008-07-27 Thread Ajoy Khaund
rom a specification are easy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -- From: "John Harvey" <[EMAIL PROTECTED]> Sent: Sunday, July 27, 2008 9:29 PM To: <[EMAIL PROTECTED]> Sub

Re: Vfp6 to Vfp9 Sql Group By

2008-07-27 Thread Ajoy Khaund
sy if both are frozen." - Edward V. Berard, "Life-Cycle Approaches" -- From: "Stephen Russell" <[EMAIL PROTECTED]> Sent: Monday, July 28, 2008 12:57 AM To: <[EMAIL PROTECTED]> Subject: Re: Vfp6 to Vfp9 Sql Gr

Re: Vfp6 to Vfp9 Sql Group By

2008-07-27 Thread Stephen Russell
On Sun, Jul 27, 2008 at 12:53 AM, Ajoy Khaund <[EMAIL PROTECTED]> wrote: > Hi All, > > I need some advice (maybe not a great day to ask as its weekend for many but > since I am at it) on a query which has a group by. I am getting some fields > from the Product master and the stock qty from produc

RE: Vfp6 to Vfp9 Sql Group By

2008-07-27 Thread John Harvey
Set enginebeharior 70 Add that setting before the query, if you want it to behave like it did in 6. JH -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ajoy Khaund Sent: Sunday, July 27, 2008 12:53 AM To: Profox Subject: Vfp6 to Vfp9 Sql Group By Hi All

Vfp6 to Vfp9 Sql Group By

2008-07-26 Thread Ajoy Khaund
Hi All, I need some advice (maybe not a great day to ask as its weekend for many but since I am at it) on a query which has a group by. I am getting some fields from the Product master and the stock qty from productlot table. Vfp6 Select a.prodname,a.iunit,a.avgcost as unitcost,sum(b.balunit