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

Resolved SQL Parsing

  1. How-to
0
Votes
Undo
  1. Markus Schröder
    Markus Schröder
  2. PowerBuilder
  3. Wednesday, 11 September 2019 09:38 AM UTC

Hello,

for simple SQL Parsing we have been using the PFC SQL Parser (pfc_n_cst_sql).

Now we switched from Oracle Join Syntax (+) to ANSI Join Syntax (left outer join...).

Is there already a parser that can handle this (preferably in Powerscript)?

Thanks

 

 

  1. PowerBuilder
  2. SQL
Datawindow/Datastore - Insert/Update if exists pro...
Datawindow border on top and double border
Responses (1)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Wednesday, 11 September 2019 13:43 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Samuel -

The simple SQL parsing performed by the PFC's pfc_n_cst_sql object (the of_parse function) only parses the "FROM" clause in its entirety. It does not examine Join syntax. I've checked the code in the 2017 Release of the PFC.

Comment
John Fauss
  1. John Fauss
  2. Wednesday, 11 September 2019 13:48 PM UTC
Oops! After a more careful reading of your question, I see that this is why you are asking...Doh! I assume you are wanting to not have to manually inspect/change the SQL syntax in your app?
  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.