The error occurs in VFP 8 SP 1.
For VFP 9 it can be accomplished with the following:
SELECT sort_key, sum(nValue) as column_Value ;
FROM (Select DATE(YEAR(Test.Date), MONTH(Test.date),01) as Sort_Key, ;
nValue FROM test) as curTemp ;
INTO CURSOR curAll ;
GROUP BY 1 ;
ORDER BY 1
Tracy
-----Original Message-----
From: Dave Crozier
Sent: Tuesday, June 26, 2007 9:04 AM
Hi Folks,
I just came across what I think is a VFP error and I'm wondering should it
be reported.
If you group by a field generated by the Date(...) function then VFP throws
an error.
Could someone confirm this is the same in VFP8 and VFP7 and if it has been
spotted previously as an error.
The same error occurs if you use DateTime() as opposed to Date.
An example below.
Dave Crozier
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
