1. Olan Knight
  2. PowerBuilder
  3. Thursday, 19 July 2018 20:51 PM UTC

PBv12.1 build 7055
Oracle 12C

What in the WORLD is going on here???????

Here's the code:
   lds_active = CREATE n_ds
   n_ds.DataObject = "d_fa_all_circuits_for_ban"    <--- this line fails
   ll_rc = lds_active.SetTransObject (sqlca)

 

When I hit the second line to assign the DataObject, I get this:

 

If I skip that line in DEBUG mode and manually add the string to the Datastore field in the object, it works perfectly.
This occurs when the object is both "n_ds" and "datastore".



Thanks,

Olan

Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:28 PM UTC
  2. PowerBuilder
  3. # 1

Well, poodlefarts and snrglemrfs!!!

I found the truly sill problem.

Change 

   n_ds.DataObject = "d_fa_all_circuits_for_ban"    

To

   lds_active.DataObject = "d_fa_all_circuits_for_ban"  


Wow, I feel schtoopid!  :O    

Thanks for your help!

 

Olan

 

Comment
  1. Chris Pollach @Appeon
  2. Thursday, 19 July 2018 21:44 PM UTC
Excellent news Olan!



In these situations, I always find that MORE COFFEE helps - LOL!
  1. Helpful
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:14 PM UTC
  2. PowerBuilder
  3. # 2

Thanks so much for your quick reply, Chris.

I tried all your suggestions, and so far...   :( 

1) Yes, the first line of the Edit Source for the new DWO is indeed "release 12;"
2) I've regenerated everything multiple times.
      Note that at first, selecting ALL of the objects in the PBL and regenerating them caused an error, however
      when I regenerated the objects one at a time, the regen succeeded.
3) At this time, the regen works on the new objects - the DWO and the function call in the NVO.
4) I exported the NVO, deleted it from the PBL, then re-imported the SRU file and regenned:  success

I've added the name of the new DWO to the PBR and am now doing a full build. Maybe that will help.
Also, I did not export, delete, and re-import the new DWO. Something to try after the full build.


Thanks Again,
Olan

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 19 July 2018 21:00 PM UTC
  2. PowerBuilder
  3. # 3

Hi Olan;

    I wonder if the DWO source is corrupted on not "up to par". If you edit the DWO source, does the 1st line read ...

release 12;

   Also, try regenerating the DWO & maybe even try an "optimize" on the DWO's PBL.

HTH

Regards ... Chris

 

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.