1. Olan Knight
  2. PowerBuilder
  3. Friday, 3 August 2018 20:36 PM UTC

PB v12.1 build 7055
Oracle 12C database


UPDATE:  ALL of my dwos are experiencing this issue!
I can connect to the database in PB and in SQL+, and in SQL+ I can select data without issue, but NON of my dwos have the RETRIEVE button enabled.




I ran into a DWO that has been around for a while.

1) I open the DWO in the DW Painter,
2) go to the SQL,
3) copy the SQL into an ISQL Session window of the database painter
4) replace the retrieval arguments with actual values
5) add a semicolon to the end 
6) Hit CNTL-L  ----> and it works and retrieves 72 rows.


HOWEVER, in the DW Painter, the RETRIEVAL button is disabled and I have no idea why, NOR have I any idea on how to get the bloody thing enabled.


I've attached a PDF of the Edit Source for the dwo.

Any suggestions?


Thanks,

Olan

Attachments (1)
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 3 August 2018 21:13 PM UTC
  2. PowerBuilder
  3. # 1

Hi Olan;

  I am not sure if this has anything to do with your predicament ... but, O12C was not supported by PB until PB 12.6 - 1st EBF release.

Regards ... Chris

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 3 August 2018 21:17 PM UTC
  2. PowerBuilder
  3. # 2

Well, it's been working with that database  - my primary development database - for two years.
Until today.

It's like a switch was thrown somewhere!!!!

 
OK, I've tried connecting to three different databases, and it the behavior is the same - it does not matter to which database I am connected, the RETRIEVE button is disabled.

 

Comment
There are no comments made yet.
Brad Mettee Accepted Answer Pending Moderation
  1. Friday, 3 August 2018 21:24 PM UTC
  2. PowerBuilder
  3. # 3

Try creating a new grid datawindow, dummy up the SQL until you can convert to syntax, then paste in your select (and set up the arguments again).

If it works, save it as new, then compare the working/non-working datawindows. Everything up to the actual layout data (columns, titles) should be pretty much the same. That should give you some indication of what's causing issues.

If it doesn't work, that indicates something with the SQL that PB is having problems parsing, but not telling you about. You'll have to start tearing it apart one piece at a time till it works, then see what you can do to replace the offending bit.

-==-----

Just saw your revisions.

What happens if you create a new DW from scratch?

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 3 August 2018 21:36 PM UTC
  2. PowerBuilder
  3. # 4

I have attempted to create a new DWO from scratch. The SQL is brain dead simple and I tested my user rights in SQL+ first, successfully.

But even a brand new dwo has the RETRIEVE button disabled.

 

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Friday, 3 August 2018 21:41 PM UTC
  2. PowerBuilder
  3. # 5

A Google search shows me the answer, provided by Terry Dykstra!

 
You've closed the preview panel by mistake.  Go to View, Layouts, Default to
reset your layout.

--
Terry Dykstra (TeamSybase)

Comment
  1. And And
  2. Friday, 6 September 2019 11:25 AM UTC
works for me!!

Thanks a lot!
  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.