>i'm using this instruction :
>
>select codigo,sum(vent) from exame group by codigo
>
>and appear this message: "There is an error in the GROUP BY clause."
>
>
>How can i solve this ?

what's the type of the field "codigo" ?
VFP 8.0 does not support GROUP BY on MEMO or GENERAL fields.

See also the chapter "Behaviour changes since VFP 7.0" in the VFP 8.0 helpfile.