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.
|
