1. James Medick
  2. PowerBuilder
  3. Thursday, 21 May 2020 20:21 PM UTC

As of this morning, all of my datawindows do not retrieve or display any data.  I can copy the SQL from the datawindow and execute it on the DB without problem.  I upgraded to the latest version, 2019 R2 Build 2328, but no difference. 

My existing app still works, but I can't use the datawindow painter to create anything new that works or even retrieve data from existing datawindows.

Any ideas?

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 21 May 2020 21:02 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi James;

  Suggestion: Turn on the SQL Trace feature. You can do this in either the IDE and/or your App. Maybe that might give you an idea as to why the datum is not being returning or the SQL is not being accepted for execution.

IDE: Look at the DB Profile for SQL tracing

App: Set SQLCA.DBMS = "TRACE XXX" // where XXX = your current DB client

Regards ... Chris

 

Comment
  1. Miguel Leeuwe
  2. Saturday, 23 May 2020 05:12 AM UTC
Happy to see you solved whatever it was. Thanks for (NOT) sharing the solution to your problem.
  1. Helpful
  1. James Medick
  2. Monday, 25 May 2020 21:07 PM UTC
I have no solution. I think it was a corrupted file in the IDE. Upgrading to a newer version (latest) has cleared it.
  1. Helpful
  1. Mike Bryan
  2. Wednesday, 27 May 2020 19:36 PM UTC
I had the same issue his morning it was bizarre, if the retrieve on the menu was assessable it did nothing . I screamed and tried a little while later and all was ok
  1. Helpful
There are no comments made yet.
James Medick Accepted Answer Pending Moderation
  1. Saturday, 23 May 2020 15:26 PM UTC
  2. PowerBuilder
  3. # 1

Looks like I had some corruption in the IDE itself.  After upgrading to the latest version, it seems to have cleared.  Not sure why.

Comment
There are no comments made yet.
Clarence Chamorro Accepted Answer Pending Moderation
  1. Saturday, 23 May 2020 15:19 PM UTC
  2. PowerBuilder
  3. # 2

did you replaced the old PowerBuilder's DLLs with the new set of DLLs.

do you have the same problem in the development machine running the application or direct retrieve from a datawindow object.

Hope this will help.

Regards,

Clarence.

Comment
There are no comments made yet.
Olan Knight Accepted Answer Pending Moderation
  1. Thursday, 21 May 2020 23:11 PM UTC
  2. PowerBuilder
  3. # 3

It sounds like the password changed for your user account on the database.
Or the credentials are not r eaching the database.


Good Luck,

Olan

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.