Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GROUP BY clause is missing or invalid - VFP 8.0/ASP page
Message
From
05/01/2004 04:47:35
Viv Phillips
Hay-On-Wye, United Kingdom
 
 
To
05/01/2004 01:19:08
Vim Ahadevan
Outlook Amusements
Los Angeles, California, United States
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: GROUP BY clause is missing or invalid - VFP 8.0/ASP page
Miscellaneous
Thread ID:
00863774
Message ID:
00863787
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
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
Previous
Reply
Map
View

Click here to load this message in the networking platform