Hi,

>>
i have an ASP page and in the page i have a SQL statement. when i run the page i get an error "GROUP BY clause is missing or invalid". if i run the same statement in VFP 8.0 i get an error unless i "set enginebehavior to 70". so the question is... is there any way to set enginebehavior to 70 from an ASP page?
>>

If you are using the VFP OLEDB provider you can use .ExecuteNonQuery() to set enginebehavior (and other environment settings)

HTH,
Viv