PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → View Multipage-PDF stored as Binary-Memo in HFSQL with Zoom-Ability
View Multipage-PDF stored as Binary-Memo in HFSQL with Zoom-Ability
Débuté par meikl, 30 nov. 2017 08:59 - 6 réponses
Membre enregistré
118 messages
Posté le 30 novembre 2017 - 08:59
Hi all,

i try to display a multipage-PDF-Document, which is stored in a binary-memo Field in a HFSQL-Server.
How to do this?

my current results are
- only the first page is shown, no possibilty to change the displayed page
- depending on the displaymode, only a part of the firstpage is shown, the PDF-page itself, will not scroll
- the automatic zoom possibilty takes as base the shown image, instead the stored, which is depending on the displaymode in a no good quality (lesser than the stored one)

so how to show a multipage PDF-Document on a webDev-Page zoom- and scrollable (in PDF-Page-content and PDF-Pages) in a good readable quality?

Thanks
meikl :)
Posté le 30 novembre 2017 - 11:46
Hi Meikl,

there is an example called wd pdf viewer, if my memory is correct, where
you can see all that in action

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 11/30/2017 à 2:59 AM, meikl a écrit :
Hi all,

i try to display a multipage-PDF-Document, which is stored in a
binary-memo Field in a HFSQL-Server.
How to do this?

my current results are
- only the first page is shown, no possibilty to change the displayed page
- depending on the displaymode, only a part of the firstpage is shown,
the PDF-page itself, will not scroll
- the automatic zoom possibilty takes as base the shown image, instead
the stored, which is depending on the displaymode in a no good quality
(lesser than the stored one)

so how to show a multipage PDF-Document on a webDev-Page zoom- and
scrollable (in PDF-Page-content and PDF-Pages)  in a good readable quality?

Thanks
meikl :)
Membre enregistré
118 messages
Posté le 30 novembre 2017 - 13:07
Thanks for reply, Fabrice,
found \WINDEV22\Examples\Unit examples\The Image control (display a PDF or a TIFF)
but this is for winDEV.

In winDEV i have no problem, but just how do the same in webDEV?
In webDEV the properties ..NumberPage, ..PageNumber and ..Zoom are not valid for an Image-Control there

any thoughts?

meikl :)
Posté le 30 novembre 2017 - 14:26
Hi

sorry, I didn't see that you were asking for webdev...

In webdev, we generally just let the browser display the pdf:
- change destination of the button/link to new browser/tab
- do a filedisplay with the correct mime type

and the pdf is displayed in a secondary tab with all the pages/zoom
management that you are used to.

If you don't want to use a separate tab, then you can use a page with an
iframe as the destination (and again, a filedisplay)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com


Le 11/30/2017 à 7:07 AM, meikl a écrit :
Thanks for reply, Fabrice,
found \WINDEV22\Examples\Unit examples\The Image control (display a PDF
or a TIFF)
but this is for winDEV.
In winDEV i have no problem, but just how do the same in webDEV?
In webDEV the properties ..NumberPage, ..PageNumber and ..Zoom are not
valid for an Image-Control there

any thoughts?

meikl :)
Membre enregistré
118 messages
Posté le 30 novembre 2017 - 15:31
Thanks for reply, Fabrice,

i do so already for PDF-Files, which are stored in the filesystem of the web-server (Site-area) ...

... but
- the PDF-File is not on the filesystem of the webserver (Site-area), its stored as binary-memo on a hfsql server-table, which is accessed by the web-application
- the PDF-Content should additional shown to other datas stored in that database on a webDEV-Page
- the visitor may loose the context in mind between the datas and the shown PDF in different Browser-TABS
- i want to avoid to create a file on the filesystem of the webserver (Site-area), because this is temporary, it has to clean up afterwards

well, seems to be impossible ...

any further suggestions?
meikl :)
Posté le 30 novembre 2017 - 15:52
Hi,

Le 11/30/2017 à 9:31 AM, meikl a écrit :
Thanks for reply, Fabrice,

i do so already for PDF-Files, which are stored in the filesystem of the
web-server (Site-area) ...

.... but
- the PDF-File is not on the filesystem of the webserver (Site-area),
its stored as binary-memo on a hfsql server-table, which is accessed by
the web-application
- the PDF-Content should additional shown to other datas stored in that
database on a webDEV-Page - the visitor may loose the context in mind
between the datas and the shown PDF in different Browser-TABS
- i want to avoid to create a file on the filesystem of the webserver
(Site-area), because this is temporary, it has to clean up afterwards

well, seems to be impossible ...

any further suggestions?


Nope, as my last message already did give you the solution... Here is it
again :
If you do not want a separate tab, use an iframe (ie INSIDE your page)
as the target for the display, and yes, you can do that with your pdf
being in the DB (that's what buffers + stringdisplay are for)

Best regards

--
Fabrice Harari
International WinDev, WebDev and WinDev mobile Consulting

Ready for you: WXShowroom.com, WXReplication (open source) and now WXEDM
(open source)

More information on http://www.fabriceharari.com

> meikl :)
Membre enregistré
118 messages
Posté le 30 novembre 2017 - 16:30
oh well, an iframe ... will try

thanks fabrice