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

Resolved Error saving excel sheet

  1. Issue
0
Votes
Undo
  1. Cintia Verissimo
    Cintia Verissimo
  2. PowerBuilder
  3. Wednesday, 9 March 2022 20:29 PM UTC

Hi,

Power Builder unexpectedly quit when saving a report as excel, xlsx extension with approximately 500,000 records, using the SaveAs method.
Are there any limitations in PowerBuilder in this case?

script: li_ret = ids_rows.SaveAs(ls_arquivo, XLSX!, True)

Regards,
Cintia Verissimo

PowerClient - Desktop LNK/Shortcut Text Value?
Any future updates for PB 2019?
Responses (1)
mike S
mike S Accepted Answer Pending Moderation
  1. Wednesday, 9 March 2022 20:43 PM UTC
  2. PowerBuilder
  3. # 1

is this a 32bit application?  Try in 64 bit

memory limit can cause it to crash.

 

 

Comment
Load more comments
mike S
  1. mike S
  2. Thursday, 10 March 2022 14:24 PM UTC
can you save a small record set without it crashing? If not, then you are missing dlls and/or .net installs.





  1. Helpful
Cintia Verissimo
  1. Cintia Verissimo
  2. Friday, 11 March 2022 13:29 PM UTC
Yes, I can save approximately 400,000 records.

Could you send the dlls and/or .net installs listing so I can check.



Regards,

Cintia Verissimo



  1. Helpful
mike S
  1. mike S
  2. Friday, 11 March 2022 14:34 PM UTC
you can save some records, so it isn't missing dlls/.net



do it in batches of say 300,000 records since 500K crashes
  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.
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.