Could it be your SET ENGINEBEHAVIOR is different on your bosses system?
"Gene Wirchenko" <genew@[EMAIL PROTECTED]
> wrote in message
news:8juab35ffj0p9g3u96a31mmgom49gsmbon@[EMAIL PROTECTED]
> My boss just re****ted a problem in an archiving program that is
> not used very often. It ran fine on my system.
>
> When I looked at the error, I was surprised that the same error
> was not occurring on my system. The error was that the GROUP BY
> clause of an SELECT was not valid.
>
> Yes, my code was not quite correct by version 9 standards. When
> I ran it on the development version, no error was thrown.
>
> When I compiled an iteration and ran it under the runtime, the
> error was thrown.
>
> I suppose that it is possible that there is something left over
> from when I had the supposed SP 2 installed.
>
> Can someone confirm a difference in SP 1 on a clean system
> (nothing later than VFP 9 SP 1 ever installed) between the development
> and runtime systems regarding bad GROUP BY clauses? By bad, I mean
> that there are non-aggregate column values that are not in the clause,
> something like:
> select one, two, sum(three), four from thetable;
> group by one, two && but not four
>
> Sincerely,
>
> Gene Wirchenko
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
|
