1. Tom McArdle
  2. PowerBuilder
  3. Friday, 27 December 2019 15: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

 

 

Michael Kramer Accepted Answer Pending Moderation
  1. Tuesday, 31 December 2019 21:05 PM UTC
  2. PowerBuilder
  3. # 1

Using ODBC, I would expect PB should handle Progress just fine as long as you stay close to ANSI-SQL syntax.

I see you write MACH-ID and DBMS complains on MACH. So:

  • Is your column actually named MACH_ID (underscore instead of dash)?
  • Can Progress accept your SQL when that column is referenced as "MACH-ID"?

Potentially same issue for other identifiers containing a dash.

HTH /Michael

Comment
  1. Tom McArdle
  2. Tuesday, 31 December 2019 21:23 PM UTC
Thank you very much Michael.



It definitely is connected to the "-" PB is expecting "_".

Based on your message I went back in and converted to SQL, then tried changing from "-" to "_" in the SQL window

Initially PB gave me an error, so I then changed it back from "_" to "-". BUT, then when I tried to run the script it worked. Seems like PB wants you to change and then change back before it works. Strange, but that seems to be the solution.



Thank you very much and Happy New Year

Tom



  1. Helpful
  1. Michael Kramer
  2. Tuesday, 31 December 2019 21:27 PM UTC
Happy to help. Clock at 22:27 CET.

Happy New Year to you too!
  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 27 December 2019 17:03 PM UTC
  2. PowerBuilder
  3. # 2

Hi Tom;

  FWIW: Appeon versions of PB do not support the Progress DBMS at this time.

Regards ... Chris

Comment
  1. Tom McArdle
  2. Friday, 27 December 2019 17:09 PM UTC
OK



Thank you for the quick response Chris

Tom
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.