1. Richard Carrier
  2. PowerBuilder
  3. Thursday, 18 July 2019 16:09 PM UTC

I added a Rows to Disk to our data window to solve memory issues. Sure it solved the memory issues, but now even on a small set of rows, the application crashes after we delete a row, then issue the Update(). Remove the rows to disk, no crash. Put it back, crashes.

 

Super special,

 

Any help really appreciated.

Thanks

Richard

Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Friday, 19 July 2019 12:53 PM UTC
  2. PowerBuilder
  3. # 1

Hi Richard;

    I have not personally used this feature for over a decade now. Its hard to say if this feature worked 100% for DB updating in the old PowerSoft days (who originally wrote the feature). All-in-all, this feature was not used in a lot of applications that I can remember. However saying that, I would suggest that you open a Support ticket for this issue as it certainly should work for generating Insert/Delete/Update DML IMHO. Who knows what changes were made in this area by Sybase and/or SAP that may have broken something in the RowsToDisk feature DB update wise.

   With the above being said, it should be easy to workaround the issue. Just use the RowsToDisk DWO as a "WIP" (work in progress) pick list for the App user. When your App wants to update something, use a second DWO that has a retrieval argument on the same table utilizing a key. Pass the key from the RowsToDisk DWO to the 2nd DWO and let it perform the DB updating (insert, Update, Delete) of that particular row, then commit. Food for thought.

HTH

Regards ... Chris

 

Comment
There are no comments made yet.
Richard Carrier Accepted Answer Pending Moderation
  1. Thursday, 18 July 2019 21:08 PM UTC
  2. PowerBuilder
  3. # 2

This is a bug that needs to be fixed. No where in the docs does it state report only. You suggested this to resolve a memory issue and now I'm stuck in "read only" mode ?

 

I worked around it by using embedded sql

 

Thanks

Richard

Comment
  1. Eduardo G.
  2. Friday, 19 July 2019 09:56 AM UTC
I agree, it must be fixed or clearly reported in the help or the option must be disabled if we have the "Allow Updates" property active.
  1. Helpful
  1. mike S
  2. Friday, 19 July 2019 13:37 PM UTC
this isn't the place to report bugs, but just to get community feedback. regardless of whether anyone else thinks something is not a bug, if you think it is then report it.

  1. Helpful
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 18 July 2019 18:25 PM UTC
  2. PowerBuilder
  3. # 3

Hi Richard;

   If I recall correctly ... the RowsToDisk option was designed for large lists or reports and not for DB updating.

Regards ... Chris

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.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.