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.