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