1. Minogue Susan
  2. PowerBuilder
  3. Wednesday, 15 May 2019 10:02 AM UTC

Hi,

In PowerBuilder 2017 R3 while we are trying to create a new data window by using stored procedure we are getting the error as SQL error state 22005 though we are giving the correct data type and if we try to create manually by adding each and every column with same data types and column names as in stored procedure we are getting error as invalid column name(getting error when we click next button after adding everything). Can anyone suggest on this issue?

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Friday, 5 July 2019 05:07 AM UTC
  2. PowerBuilder
  3. # 1

Try using these dbparm parameters

 

Set the DBParm StripParmNames='Yes' and CallEscape='No' when
connecting to the database.
Comment
  1. Jeong Hwan Jang
  2. Thursday, 2 April 2020 01:13 AM UTC
Thanks Miguel.
  1. Helpful
  1. Miguel Leeuwe
  2. Thursday, 2 April 2020 08:03 AM UTC
YW, did it solve your problem?
  1. Helpful
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.
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.