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

Resolved Blob not working

  1. How-to
0
Votes
Undo
  1. Dhruv Jain
    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.

  1. BLOB
  2. ODBC
PB 2022 R3 Consume .net dll in PB 2022
PB Automatic Builds - PB2022R2
Responses (1)
Miguel Leeuwe
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
Dhruv Jain
  1. Dhruv Jain
  2. Tuesday, 21 May 2024 11:36 AM UTC
using SELECTBLOB only

  1. Helpful
Roland Smith
  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.