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

Resolved modification of blob type

  1. How-to
0
Votes
Undo
  1. william yau
    william yau
  2. PowerBuilder
  3. Wednesday, 23 February 2022 02:20 AM UTC

Hi Guru

 

 I would like to modify address in sales template which stored blob type in sql server.  would you advise me how to do that

 

for example ; How to convert blob type to bmp and convert to bmp to blob type 

 

 

william

Page count across nested reports in composite rpt
SaveAs to Excel 12 from PowerBuilder version 2021
Accepted Answer
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Wednesday, 23 February 2022 02:36 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi William;

   The Blob type in SS for BMP files would be the "Image" data type. To load & unload image data to/from SS, you would use the PowerBuilder SelectBlob & UpdateBlob commands.

Regards ... Chris

Comment
william yau
  1. william yau
  2. Wednesday, 23 February 2022 04:05 AM UTC
Hi Chris

my template is word doc with signature. I would like to ask if use "updateblob" command to update sql server after finish modification word format



William











  1. Helpful
Miguel Leeuwe
  1. Miguel Leeuwe
  2. Wednesday, 23 February 2022 11:35 AM UTC
Yes, that's what Chris was saying: "Use SelectBlob and Updateblob".

regards.
  1. Helpful 1
william yau
  1. william yau
  2. Thursday, 24 February 2022 04:17 AM UTC
Hi Miguel

my codes are below , it seems not work , would you have any comment





int fh

blob Emp_id_pic

fh = FileOpen("c:\opensoft\temp.dot", StreamMode!)



IF fh <> -1 THEN



FileRead(fh, emp_id_pic)

FileClose(fh)

UPDATEBLOB report_store SET rs_ole1 = :Emp_id_pic

WHERE rs_cono= :ls_cono

AND rs_module = :istr_repinfo.module

AND rs_repid = :istr_repinfo.repid

USING SQLSYS;

END IF



William

  1. Helpful
There are no comments made yet.
Responses (1)


There are replies in this question but you are not allowed to view the replies from 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.