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

Resolved ShareData Quandry

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Monday, 18 March 2019 21:40 PM UTC

PowerBuilder v12.1, build 7055
PB Classic
Oracle 12C

I have two datawindows: dw_1 and dw_2.

Dw_1 is the primary, the original dw.
I did a SAVE AS and copied dw_1 into dw_2.

Next, I removed the RETRIEVE statement from dw_2 in Edit Source mode, and replaced it with a ")".

Then I removed the name of the database table from dw_2, turning dw_2 into an External dwo.

ll_rc = dw_1.ShareData (dw_2)

ll_r is -1. Every time, and I've no idea why.
I've attached both SRDs in a 7-Zip archive file with their extentions renamed from ".srd" to ".txt". I had to rename the file from "Sharedata.7z" to "Sharedata.zip" in order to get it to upload into this forum.

dw_1 = dw_ic_detail
dw_2 = dw_ic_lpc_terms_setup

 

I'd appreciate any help on getting this to work!

Thanks In Advance -
Olan

Attachments (1)
Sharedata.zip
Connected users => datawindow SQL Anywhere db
Rest client proxy
Responses (2)
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 19 March 2019 03:28 AM UTC
  2. PowerBuilder
  3. # 1

Hi Olan,

 

Out of curiosity: Is there really a need to edit the source and get rid off the sql?

I always simply leave the dw copy as is. The sql doesn't bother since you're not doing a retrieve anyway.

regards,

Miguel

Comment
Olan Knight
  1. Olan Knight
  2. Tuesday, 19 March 2019 19:26 PM UTC
There's no real need to do so. I just like to keep my external DWOs as clean as possible.
  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Tuesday, 19 March 2019 19:33 PM UTC
Thanks for your answer :)
  1. Helpful
There are no comments made yet.
Olan Knight
Olan Knight Accepted Answer Pending Moderation
  1. Monday, 18 March 2019 22:22 PM UTC
  2. PowerBuilder
  3. # 2

Update:

Well, something must have happened on the first lap around the block. I re-did the steps listed above, and it works now.

.....I don't care, I'll take it.  :/

 

Olan

Comment
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Tuesday, 19 March 2019 12:45 PM UTC
Hi Olan;

External DWO's are no problem to use. The key that many PB developers often miss with ShareData() is that not only do you need the same columns & data types as in the primary DWO - the columns must be in the same order as the primary DWO - otherwise the share will fail.

Glad that you got this working!

Regards ... Chris
  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.