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

Resolved Generate C# Model Syntax Issue (Oracle)

  1. How-to
0
Votes
Undo
  1. Thomas Rolseth
    Thomas Rolseth
  2. SnapDevelop
  3. Thursday, 24 October 2019 11:12 AM UTC

I'm getting a parsing error in the C# model generator for a datawindow that I am not sure how to resolve -- see attached.  The datawindow works fine in PB when doing a preview and passing the required arguments.  The issue appears to related to a subselect where I use the Oracle LISTAGG function to combine multiple values in a comma delimited string.  Is there a way to adjust the SELECT statement so that it can be exported to my web api?

Thanks, Tom

Attachments (1)
appeon_issue_image.jpg appeon_issue_image.jpg
  1. Oracle
  2. PowerBuilder (Appeon)
  3. SnapDevelop
Failed Unit Tests in SnapDevelop
c# model generator Oracle
Responses (1)
Logan Liu @Appeon
Logan Liu @Appeon Accepted Answer Pending Moderation
  1. Friday, 25 October 2019 17:48 PM UTC
  2. SnapDevelop
  3. # 1

Hi Tom,

I suggest that you submit a standard support ticket for this bug.

I don't have a good solution. May be you can use the Oracle XMLAGG function instead of the Oracle LISTAGG function to work around this issue.

E.g.:

XMLAGG (XMLELEMENT (e, se1.email || ',') ORDER BY se1.email).EXTRACT ('//text()')

Regards,
Logan

Comment
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.