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

Resolved Datawindow - limited retrieval problem

  1. Issue
0
Votes
Undo
  1. John Vanleeuwe
    John Vanleeuwe
  2. PowerBuilder
  3. Thursday, 16 August 2018 14:35 PM UTC

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

encrypt using SSL
Unable to Connect ODBC after Web Deployment
Accepted Answer
Clarence Chamorro
Clarence Chamorro Accepted Answer Pending Moderation
  1. Thursday, 16 August 2018 16:53 PM UTC
  2. PowerBuilder
  3. # Permalink

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

Comment
John Vanleeuwe
  1. John Vanleeuwe
  2. Thursday, 16 August 2018 21:40 PM UTC
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. Helpful
There are no comments made yet.
Responses (3)
John Vanleeuwe
John Vanleeuwe Accepted Answer Pending Moderation
  1. Friday, 17 August 2018 12:02 PM UTC
  2. PowerBuilder
  3. # 1

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

My apologies.

 

 

John

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

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
John Vanleeuwe
  1. John Vanleeuwe
  2. Thursday, 16 August 2018 21:37 PM UTC
PB 11 i know , but has been good for years , with SQL Anywhere 11.



John
  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.