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

Resolved Data does not load to PB interface

  1. Advice
0
Votes
Undo
  1. Kelvin Doan
    Kelvin Doan
  2. PowerBuilder
  3. Friday, 18 February 2022 15:48 PM UTC

I upgraded our current PB application to version 2019. The application is used to create PB reports. All the criteria of reports are saved to Sybase tables. After upgrading to the version 2019, I tried to open our reports , none of  report is loaded to datawindow, BUT when I create the new report  and reopen it , the new report is loaded, no problem. Anyone has any ideas why it happened ? Thank you. 

What is the absolute path value in Fileexists func...
Create application object failed
Responses (6)
mike S
mike S Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 16:02 PM UTC
  2. PowerBuilder
  3. # 1

what version of PB did you migrate from?

 what sybase database?  ASE? 

 

what exactly do you mean by criteria?  Just data (parameter values for the report), or do you mean the reports themselves?

also, not sure what you are describing.  are you running your report application and select a report to run and the report doesn't run?

 

did you run your application in the debugger so you can see what is happening?

 

Comment
There are no comments made yet.
Roland Smith
Roland Smith Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 16:20 PM UTC
  2. PowerBuilder
  3. # 2

Does this involve PSR files?

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 16:59 PM UTC
  2. PowerBuilder
  3. # 3

Hi Kelvin;

   Are you connecting to the correct instance of ASE in your PB IDE that has the related data?

Regards .... Chris

Comment
There are no comments made yet.
Kelvin Doan
Kelvin Doan Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 17:20 PM UTC
  2. PowerBuilder
  3. # 4

Thank you for your reply. The application does not use PSR file. The function of application is : user enters the criteria (condition) for report such as column a = 3 for record = abc on the data window , then all data will be saved to  different of Sybase tables (version 16) , when the user wants to generate reports , the application collects data which users enter before and create reports. The problem is : with new version of PB is :when the user tries to open the previous saved report, the report is not loaded on screen (the screen is blank)  for user to modify or resave .... , but if the user creates a new report with new condition, when the user reopen the new report , it's ok ,   all the conditions are loaded. We upgraded PB from 7 to 2019

Comment
John Fauss
  1. John Fauss
  2. Friday, 18 February 2022 18:38 PM UTC
If newly-created reports are working OK, but old reports created in PB 7 are not, I suspect ANSI -> Unicode complications. PB was changed internally beginning in version 10 to use Unicode 16LE (2-bytes/character). Prior to version 10, it used ANSI (single byte/character).
  1. Helpful
There are no comments made yet.
Kelvin Doan
Kelvin Doan Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 17:28 PM UTC
  2. PowerBuilder
  3. # 5

The application connects to the correct database because I do the query on the database , I can see the name of new reports and old reports on tables. Thank you. 

Comment
There are no comments made yet.
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 18 February 2022 18:50 PM UTC
  2. PowerBuilder
  3. # 6

Hi Kelvon;

  Can you trying editing one of the DWO's source code in PB2019? Then check the 1st line of the source code for the value "release 19;" if the DWO source does not state the value 19, please change the "release NN;" to 19 & then save the DWO.  Then try to run the DWO again.

Regards ... Chrids

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.