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

Resolved How to add a new column to a datawindow when source is Stored Procedure

  1. How-to
0
Votes
Undo
  1. Gregory Rusak
    Gregory Rusak
  2. PowerBuilder
  3. Thursday, 23 September 2021 23:23 PM UTC

PowerBuilder 2021

Hello,

Once a datawindow has been created from a Stored Procedure Source, how does one go about adding a new column to that same datawindow after the Stored Procedure has been updated and a new column added to the result set?

Is the only way by editing the datawindow source code and carefully adding the column to the list?

 column=(type=ulong updatewhereclause=yes name=medrenew_provider_added_ind dbname="medrenew_provider_added_ind" )
 procedure="1 execute app_owner.return_pharmacy_renewals;0 p_emailmsg_id = :p_emailmsg_id" arguments=(("p_emailmsg_id", number)) )

Thanks in advance.

Greg

2010 Microsoft runtime DLLs security issues
CoderObject lco_Code HttpClient lhc_Client
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 24 September 2021 17:09 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Gregory;

  In this example, I am going to add the Phone column to the SP, as follows:

1) Revise the SP to add the new column (ie: in the DB Painter).

2) Open the affected DWO and validate the SP as the data source. Reselect the same SP or revise the SP to be the source.

3) Use the column specification pane to add the new column (same name as used in the SP).

4) Add the column to the "design" pane and then preview.

HTH

Regards ... Chris

 

 

 

Comment
Gregory Rusak
  1. Gregory Rusak
  2. Friday, 24 September 2021 17:17 PM UTC
Most Excellent Chris. Never would have looked there and likely better than trying to mess with source code. Appreciate the effort. Regards.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 24 September 2021 20:39 PM UTC
You are most welcome!
  1. Helpful
There are no comments made yet.
Responses (2)
Ronnie Po
Ronnie Po Accepted Answer Pending Moderation
  1. Friday, 24 September 2021 17:08 PM UTC
  2. PowerBuilder
  3. # 1

Hi Greg,

In the Column Specifications tab of the DW painter, right-click anywhere in the column listing to get Insert, Add, Delete... menu options. Or to add a column at the end, just tab/down arrow off the last row.

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