Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved ODBC Progess Database question

  1. How-to
0
Votes
Undo
  1. Tom McArdle
    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

 

 

Upsert in postgresql
Need info on how to access AWS S3 from PB
Responses (2)
Michael Kramer
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
Tom McArdle
  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
Michael Kramer
  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
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
Tom McArdle
  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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.