1. mike S
  2. PowerBuilder
  3. Monday, 26 February 2018

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 Accepted Answer Pending Moderation
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
support states that there is no plan to have pb  will  fully work with postgresql.

  1. mike S
  2. Wednesday, 28 February 2018
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
There are no comments made yet.
  1. Tuesday, 27 February 2018
  2. PowerBuilder
  3. # Permalink


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