1. Dhruv Jain
  2. PowerBuilder
  3. Tuesday, 21 May 2024 06:40 AM UTC

Hi,

We have stored icon.bmp stored as a blob in MSS DB, and we are trying to fetch that file in code but blob is able to fetch only 32767 bytes data.

We tried adding PBMaxBlobSize in dbparams through ODBC connections, but it doesnt helped. Is their any way to download whole icon file.

Miguel Leeuwe Accepted Answer Pending Moderation
  1. Tuesday, 21 May 2024 11:07 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

That's the limit for a field in a datawindow, even for blob fields. You'll have to use SELECTBLOB to get the full size of the file.

Comment
  1. Dhruv Jain
  2. Tuesday, 21 May 2024 11:36 AM UTC
using SELECTBLOB only

  1. Helpful
  1. Roland Smith
  2. Tuesday, 21 May 2024 12:15 PM UTC
Did you use FileReadEx when loading the file into the database? FileRead can only read 32,767 bytes because that is the limit of an Integer. FileReadEx can read up to the limit of a Long - 2,147,483,647.
  1. Helpful 2
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.