DPLLoadFromString for PowerBuilder

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   I'm currently using PowerBuilder 11.5 and trying to load a PDF from a string.  The PDFs in this application are stored in a SQL Server database as BLOBs.

For some reason I can't get DPLLoadFromString to work correctly.

Here is some of the code :

long il_instance_id
long li_ret
string ls_doc, ls_buf
long ll_len
blob lbob_doc

il_instance_id = DPLCreateLibrary()
li_ret = DPLunlockkey(il_instance_id, ls_debenu_key)
if li_ret = 0 then 
 messagebox('Error','Could not unlock the Debenu tool.')
 return false
end if
ls_doc = string(lblob_doc)  //lblob_doc is a PDF blob from the database
ll_len = len(ls_doc)
ls_buf = DPLCreateBuffer(il_instance_id, ll_len)
if ls_buf = '0' then
 messagebox('Error','Could not create buffer.')
 return false
end if
DPLAddToBuffer(il_instance_id, ls_buf, ls_doc, len(ls_doc))
li_ret = DPLLoadFromString(il_instance_id, ls_buf,'')
if li_ret = 0 then 
 messagebox('Error','Could not load the document (' + string(dpllasterrorcode(il_instance_id)) + ')')
 return false
end if
DPLReleaseBuffer(il_instance_id, ls_buf)

Any ideas?
Thanks!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
KANASTASI Members Profile Find Members Posts Beginner Joined: 11 Mar 13 Status: Offline Points: 2	Post Options Post Reply Quote KANASTASI Report Post Thanks(0) Quote Reply Topic: DPLLoadFromString for PowerBuilder Posted: 11 Mar 13 at 7:03PM
	I'm currently using PowerBuilder 11.5 and trying to load a PDF from a string. The PDFs in this application are stored in a SQL Server database as BLOBs. For some reason I can't get DPLLoadFromString to work correctly. Here is some of the code : long il_instance_id long li_ret string ls_doc, ls_buf long ll_len blob lbob_doc il_instance_id = DPLCreateLibrary() li_ret = DPLunlockkey(il_instance_id, ls_debenu_key) if li_ret = 0 then messagebox('Error','Could not unlock the Debenu tool.') return false end if ls_doc = string(lblob_doc) //lblob_doc is a PDF blob from the database ll_len = len(ls_doc) ls_buf = DPLCreateBuffer(il_instance_id, ll_len) if ls_buf = '0' then messagebox('Error','Could not create buffer.') return false end if DPLAddToBuffer(il_instance_id, ls_buf, ls_doc, len(ls_doc)) li_ret = DPLLoadFromString(il_instance_id, ls_buf,'') if li_ret = 0 then messagebox('Error','Could not load the document (' + string(dpllasterrorcode(il_instance_id)) + ')') return false end if DPLReleaseBuffer(il_instance_id, ls_buf) Any ideas? Thanks!

Wheeley Members Profile Find Members Posts Senior Member Joined: 30 Oct 05 Location: United States Status: Offline Points: 146	Post Options Post Reply Quote Wheeley Report Post Thanks(0) Quote Reply Posted: 11 Mar 13 at 9:11PM
	I don't think this will work. The string statement converts the binary data of the blob into unicode characters. You are going to have to write the blob to disc first with FileWriteEX and than open it with LoadFromFile. Wheeley

KANASTASI Members Profile Find Members Posts Beginner Joined: 11 Mar 13 Status: Offline Points: 2	Post Options Post Reply Quote KANASTASI Report Post Thanks(0) Quote Reply Posted: 12 Mar 13 at 12:54PM
	Thanks Wheeley for the reply. I was hoping I could do all of the PDF work without going to disk. If I use the ActiveX method do I still have to go to disk?

Wheeley Members Profile Find Members Posts Senior Member Joined: 30 Oct 05 Location: United States Status: Offline Points: 146	Post Options Post Reply Quote Wheeley Report Post Thanks(0) Quote Reply Posted: 13 Mar 13 at 1:56AM
	I think your problem is the string function in Powerbuilder. So the ActiveX will fail also. You could test this of course by writing the blob and the string to 2 different files and then try opening both of them as a pdf. My gut is telling me that the one which as a string will fail. Wheeley