1. mike S
  2. PowerBuilder
  3. Monday, 26 February 2018 22:13 PM

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.

 

 

 

 

 

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Tuesday, 27 February 2018 16:00 PM
  2. PowerBuilder
  3. # Permalink
0
Votes
Undo

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
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. mike S
  2. Tuesday, 27 February 2018 21:00 PM
support states that there is no plan to have pb  will  fully work with postgresql.

  1. mike S
  2. Wednesday, 28 February 2018 14:37 PM
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. mike S
  2. Wednesday, 7 March 2018 18:18 PM
There are no comments made yet.


There are replies in this question but you are not allowed to view the replies from this question.