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
- You are here:
-
Home
-
Q&A
-
Q&A
-
PowerBuilder
- modification of blob type
-
william yau
- PowerBuilder
- Wednesday, 23 February 2022 02:20 AM UTC
There are replies in this question but you are not allowed to view the replies from this question.
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
regards.
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