Hi Fabio,

Your post only proves that Visual FoxPro UPDATE-SQL isn't compliant with the ANSI SQL standard. It doesn't make it a bug. By the way, I agree with you that Visual FoxPro SQL command shoul be comliant with ANSI SQL as much as possible so it would be easier to work with different backends.


It is for that I have written this now,
inasmuch as many things are changed in SQL Engine of VFP ( GROUP BY, TOP , ...),
could be made an ulterior small effort.