I am encountering some difficulty in using the Janus Gridex object in
an application I am developing. Using the command window, I can set
ENGINEBEHAVIOR 70 and get the following command to work the way I want it to:
SELECT company,company.phone,email,company.address,company.city,
company.post_code,company.cidcomp,people.name
from company,cmpeopl LEFT OUTER JOIN people ON cmpeopl.cidpeop = people.cidpeop where company.cidcomp = cmpeopl.cidcomp and ! empty(company) group by company
However, if I place this code into the Gridex object and try to run the form, I get an
"Invalid Group by clause" error which I can resolve by adding all returned columns into the GROUP BY clause. Is there any way to modify the Enginebehavior of the underlying VFP ODBC driver, or is there something else I should be looking at?
Andrew
On a CLEAR day you can see forever.