- Tom McArdle
- PowerBuilder
- Friday, 27 December 2019 03:27 PM UTC
Hi Guys
Hopefully someone can point me in the right direction.
I'm using an ODBC driver to connect to a Progress Database
'Progress OpenEdge 10.2B Driver'
Everything seems to work fine until I try and use the GROUP BY clause
SELECT pub.sfeventcds.mach-id
FROM pub.sfeventcds
WHERE ( pub.sfeventcds.start-time >= :from_time ) AND
( pub.sfeventcds.end-time <= :to_time ) AND
( pub.sfeventcds.mach-id = :mach_id ) AND
( pub.sfeventcds.stat-code = '700' )
GROUP BY pub.sfeventcds.mach-id
When I try and run I get this error
Any ideas?
Thank You Tom
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.