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

Resolved PostgreSQL - Stored procedure datawindows with parameters don't work when function has parameters

  1. Issue
0
Votes
Undo
  1. mike S
    mike S
  2. PowerBuilder
  3. Monday, 26 February 2018 22:13 PM UTC

PB 2017 R2 Build 1756   using PostgreSQL

I am unable to get a datawindow to create with source of stored procedure to work if the function (procedure) uses parameters.

" Error:   Cannot create datawindow, Error column "myparameter" does not exist ; error while executing the query"

The stored function works/runs fine in pgadmin, but it doesn't work in PB.  If the stored function does not use any parameters then it works fine.

 

 

 

 

 

  1. PostgreSQL
PB 2017 lab tutorial question
Remote PowerServer and Web server installation and...
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 February 2018 16:00 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Mike;

  In my quick testing of the PostgreSQL feature I found the same issues. If you have a simple test case on each, please open a Support Ticket for these items.

Many thanks in advance!

Regards ... Chris

Comment
mike S
  1. mike S
  2. Tuesday, 27 February 2018 21:00 PM UTC
FWIW, it does appear that the "returns TABLE" syntax does now work in R2, so at least that is something (that didn't work in prior versions).  So just the Parms still don't work....



 

  1. Helpful
mike S
  1. mike S
  2. Wednesday, 28 February 2018 14:37 PM UTC
support states that there is no plan to have pb  will  fully work with postgresql.

  1. Helpful
mike S
  1. mike S
  2. Wednesday, 7 March 2018 18:18 PM UTC
It works!  Just not with parameter names:



The odbc connection MUST have "strip parameter names" checked/selected.  This is in the syntax section of the database profile setup. 



In the connection string it is:    StripParmNames='Yes'

  1. Helpful 1
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from 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.