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

Resolved Adding a ddlb to an existing DW

  1. How-to
0
Votes
Undo
  1. Nick R
    Nick R
  2. PowerBuilder
  3. Thursday, 20 August 2020 16:40 PM UTC

Hi,

Can someone please help me with adding a ddlb to an existing dw? I have added a column in the table in the backend that takes numbers(0,1,2...). In the frontend, i have made changes from Design -> DataSource -> selected the column.

These steps brought the column onto the data window. I have made the styleType -> DDLB. Added the values to the Code table -> Display Value, Data Value. These data values(numbers 0,1,2...) should be saved to the backend basing on the display value that is selected in the frontend.

Now, my question is, what are the other changes that needs to be done? Because, with these, i do not see my changes when i run the application. I have read the PB manual and googled too but, there are not of great help.

Any help is greatly appreciated.

 

Thanks!

Find out column name in an expression.
Application getting closed after save the DW using...
Responses (3)
Nick R
Nick R Accepted Answer Pending Moderation
  1. Monday, 24 August 2020 17:49 PM UTC
  2. PowerBuilder
  3. # 1

Thank you for the detailed explanation, John.

I am pretty sure that i am using DDLB for the new column that i have added. I am supplying the values in the code table. I have attached the screenshots of both DDLB and DDDW that I have here with some mock data. 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 20 August 2020 18:25 PM UTC
  2. PowerBuilder
  3. # 2

Hi Nick

1) Only the "Data Value" is populated in the parent DWO's column and thus, this value is sent to the DBMS

2) Make sure that the column where the DDLB is attached to is marked up-datable.

Regards ... Chris

Comment
Nick R
  1. Nick R
  2. Thursday, 20 August 2020 19:29 PM UTC
Under "Specify Update Properties" -> Updatable Columns: -> the new column i have created is selected. I think that's what you meant Chris, isn't it?



thank you!
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Thursday, 20 August 2020 19:56 PM UTC
Correct. If that is selected, any change to the primary column should then be sent to the DBMS on an Update() request.
  1. Helpful
There are no comments made yet.
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 20 August 2020 18:07 PM UTC
  2. PowerBuilder
  3. # 3

Greetings, Nick -

There are several things to check:

1. Is the newly added column object that uses the DDLB edit style visible?
2. Is the newly added column positioned where it will not be cropped (out of sight) in the DW Control?
3. You have saved the changes to the DataWindow?
4. The pbl where the newly-changed DW resides is in the application's library list when the app runs?
5. Are you running the application from the PB IDE? If not, you first have to recompile (Deploy).
6. Did you happen to change the name of the DW that contains the newly-added column? If so, you also need to change the DataObject name in the DW Control to match the new name.

HTH, John

Comment
Load more comments
Nick R
  1. Nick R
  2. Tuesday, 8 September 2020 15:28 PM UTC
Thank you for all your prompt responses John and Chris. I have figured this one out. This DW was nested in another window and i had to make same changes to that window as well and that fixed the issue. Appreciate your time and effort on this.
  1. Helpful
John Fauss
  1. John Fauss
  2. Tuesday, 8 September 2020 16:09 PM UTC
Good news! Thanks for letting us know.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Wednesday, 9 September 2020 00:30 AM UTC
That's awesome!
  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.