1. John Vanleeuwe
  2. PowerBuilder
  3. Thursday, 16 August 2018 14:35 PM

Hi all,

 

I know the solution is simple, but i can't find / remember it anymore.

 

i have had an application working great at a customer. After a few months customer asked me to change some minor things. Suddenly all his datawindows are retrieving only 36 or 37 records ?  Even though there are thousands of records in the database. When i ask for the rowcount in the retrieve end , i end up having 36 or 37 ...

Any idea what caused this please ? We didnt migrate or anything , same old same old PB installation...

 

TIA

John

Accepted Answer
Clarence Chamorro Accepted Answer Pending Moderation
  1. Thursday, 16 August 2018 16:53 PM
  2. PowerBuilder
  3. # Permalink
0
Votes
Undo

Maybe you have the Retrieve Options Rows As Needed turn On.

Comment
Been using this for years , PB does autoscroll whenever i set this on. I don't see why suddenly this doesn't work anymore ?



Anything extra i can check ?



TIA

John



  1. John Vanleeuwe
  2. Thursday, 16 August 2018 21:40 PM
There are no comments made yet.
John Vanleeuwe Accepted Answer Pending Moderation
  1. Friday, 17 August 2018 12:02 PM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

We got it fixed :( , sorry our internal fault. 

My apologies.

 

 

John

Comment
What was the issue?
  1. Kevin Ridley
  2. Friday, 17 August 2018 12:24 PM
There are no comments made yet.
Bruce Armstrong Accepted Answer Pending Moderation
  1. Thursday, 16 August 2018 16:06 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Help to know a bit more about the software environment.  What version of PowerBuilder are you using?  What database are you working with?

I know one version of PowerBuilder had an issue when columns in Oracle were resized to a higher length than the datawindow had originally been created based on.  When any data came in with a longer length in any of those columns than the column could handle, the retrieve would suddenly stop.  No error message or other indication what the problem was.

Comment
PB 11 i know , but has been good for years , with SQL Anywhere 11.



John
  1. John Vanleeuwe
  2. Thursday, 16 August 2018 21:37 PM
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.