GROUP BY Clause Problem in VFP8

From: Steve Meyerson (stevemeyerson_at_cox.net)
Date: 10/16/04

  • Next message: Fred Taylor: "Re: GROUP BY Clause Problem in VFP8" 
    Date: Sat, 16 Oct 2004 17:53:43 -0400

    The following worked fine in VFP6:

    SELECT CheckName, Ssn ;
      FROM Payroll ;
      INTO TABLE TempPay ;
      GROUP BY CheckName

    In VFP8 I get the error msg:

    SQL: GROUP BY clause is missing or invalid

    even when I ran it from the command window.

    It will work ok if I SELECT only one field instead of 2 or more, but
    that's not acceptable.

    Payroll is a free dbf. I tried copying Payroll.dbf to "convert" it in
    case that was necessary. I also created a simple dbf in VFP8 and got
    the same behavior.

    Any clue what's going on? Thanks for any help.

    Steve Meyerson

  • Next message: Fred Taylor: "Re: GROUP BY Clause Problem in VFP8"