Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY 1 no longer works
Message
From
17/02/2003 12:41:12
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00750415
Message ID:
00754153
Views:
41
Hi Sergey,
SNIP
>
>I pointed to this problem many times. Here're a few examples:
>
>- Re: Insonsistent Data Returned Message #558004
>- Re: Select Max(field1) + its corresponding fields? Message #571657
>- Re: Problem with MAX() in SELECT Message #609503
>- Re: SELECT SQL and MAX() Message #609504
>- Re: Problem in writing SQL(detail) Message #681074

I knew you'de find them if they were there < s >

>
>>In any case, I would have PREFERRED a different implementation. But we get what we get.
>
>Hah? VFP8 implementation is consistent with ANSI standard. Why would they do it dufferently?

No, I don't think ANSI has a "SET ENGINEBEHAVIOR". It is the VFP8 IMPLEMENTATION that I would rather have seen done differently.
My preference would have been along the lines of reporting the potential problem of ANSI comaptibility in a SYS(3054) message or such BUT otherwise leaving either as valid within VFP. That way no code would have been 'broken' and implementation of VFP8 could happen unimpeded with plans to later address the ANSI issues.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform