-
Olan Knight
- PowerBuilder
- Monday, 22 August 2022 10:48 PM UTC
PB2019R3
Oracle 12C for now, then we get to do this in PostgreSQL v12 where the datatype = "bytea"
Windows 10 platform
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
UPDATE on 28-AUG-2022:
This works:
With all the status and error checking, and all the WHAT-IFs removed, here's my code to store the PDF as a blob:
ls_pathfile = Trim (sle_pdf.Text )
ll_fileno = FileOpen (ls_pathfile, StreamMode!, Read!, Shared!)
ll_bytes = FileReadEx (ll_fileno, lblob_pdf)
UPDATEBLOB notice_list
SET pdf_blob = :lblob_pdf
WHERE bill_fccid = :is_billfccid
AND notice_idx = :ll_idx
USING sqlcA;
sqlca.sqlCode = 0
sqlca.sqlNRows = 1
With all the status and error checking, and all the WHAT-IFs removed, here's my code to reconstruct the blob as a PDF:
SELECTBLOB pdf_blob
INTO :lblob_pdf
FROM notice_list
WHERE bill_fccid = :is_billfccid
AND notice_idx = :ll_idx
USING sqlca;
ls_label = dw_text.GetItemString (1, "label")
ls_filename = "<valid path>" + "_" + ls_label + ".pdf"
ll_filenew = FileOpen (ls_filename, StreamMode!, Write!, LockReadWrite!, lwn_writemode)
ll_rc = FileWriteEx (ll_filenew, lblob_pdf)
ll_rc = FileClose (ll_filenew)
It's literally that simple, but learning the above was difficult and the HELP files were not much help.
Hopefully others can use this blessedly simple tutorial! :)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
This is stupid simple in concept, so I MUSt be doing something wrong.
I want to:
1) Save a PDF into the database
2) Retrieve the PDF file from the database
3) Append the PDF to my invoice, which is a PrintJob with multiple DWs Printing to a single PDF file using NativePDF.
After much research, the plan is to use blobs.
I was able to create a BLOB column in the table:
// I can convert the file into a blob and save it
1) Call FileOpen() in StreamMode
2) Call FileReadEx() in a loop reading 32765 bytes at a time into a blob variable
3) Call FileClose () when the read loop completes
4) Call UpdateBlob() to save into an existing entry in the database
// Read the blob from the database
1) Use BlobMid() in a loop to read the PDF file from the database into a blob variable
Now what?
I can write the data to a new file, but then how do I append the new PDF file to my dw PrintJob generated invoice?
What I want to do (I think) is add the blob to a DW whose freeform, external DWO only has a single BLOB column in it.
Sadly, I cannot make this work.
In the Database Painter, when I click on the column "pdf_blob" to add the column to the DWO, I get this:
I've no idea what this means.
I cannot find any examples or explanation of this error, nor steps on how to resolve it.
How can I get the PDF file, either from a blob format or from an actual PDF file, into a DW so I can append it to my current PrintJob?
Or is there a better wayto append the PDF to the invoice?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.