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.