Does your code actually STORE the PDF file in a table? That's what Bob is
asking for, and I was under the impression that PDFs could not be saved in a
table, only a link to their location
Karen
On Thursday, November 27, 2025 at 06:54:59 AM CST, Dewan Monjoruzzaman
<[email protected]> wrote:
Dear Mr. Dr. Robert Rugilo,
Greetings.
We frequently use R:Base to store PDF files in our software. I shared my
script. I will be pleased if it helps you.
----Start
CLEAR VAR vfile1,vfile2,vcap,iv%
SET VAR vfile1 TEXT = NULL,vcap TEXT ='Loading PDF'
CLS
PLUGINS loadfilename.rbl vfile1 +
|FULLPATH on |TITLE 'Select file to upload PI Copy' +
|FILTER image files .BMP,.JPG |FILTER all files *.* +
|MULTISELECT off |SHOW_HIDDEN off +
|NO_LONG_NAMES off |OLD_STYLE off +
|NO_NETWORK_BUTTON off |HIDE_READ_ONLY on +
|NO_CHANGE_DIR on
IF vfile1 IS NULL OR vfile1 ='[Esc]' THEN
RETURN
ENDIF
SET VAR vstoring_dt TEXT =((FORMAT(.#DATE,'mmm-yy')))
SET VAR vdirectory TEXT=('D:\PI\'+.vstoring_dt)
SET VAR vdir_check INTEGER =(CHKFILE(.vdirectory))
IF vdir_check = 0 THEN
SET ERROR MESSAGE 2269 OFF
MKDIR .vdirectory
SET ERROR MESSAGE 2269 ON
ENDIF
---Create an URL where the file will be saved. Here 'vpiuid' is my PI
identificatin no.
SET VAR vfile2 =(.vdirectory+'\'+(CTXT(.vpiuid))+'.pdf');
SET ERROR MESSAGE 2077 OFF
--If already exist
ERASE .vfile2
--Copy the file to the directory
COPY .vfile1 .vfile2
SET ERROR MESSAGE 2077 ON
--Update the file url in a column of a table. Also record the user who stores
the file and the storing date.
UPDATE pi_upload SET pi_pdf =.vfile2,upl_by =.vuid,upl_dt =.#now WHERE piuid
=.vpiuid
RECALC
--To retrieve the file in a PDF viewer
IF vpi_pdf IS NOT NULL THEN
PROPERTY pi_pdf FILENAME .vpi_pdf
ELSE
SET VAR vblank_file TEXT = 'D:\utah\pi\blank.pdf'
PROPERTY pi_pdf FILENAME .vblank_file
ENDIF
RETURN
----End
To retrieve the file in a PDF viewer placed in a form. Please add the code in
the EEPs.
---Start
IF vpi_pdf IS NULL THEN
PAUSE FOR 2 USING 'PI not yet Uploaded' CAPTION 'Warning!' ICON stop
ELSE
LAUNCH .vpi_pdf |||MAXIMIZED
ENDIF
RETURN
---End
Bestregards,
DewanMonjoruzzaman
ManagerSoftware | Utah Group
M: +8801916864347
W: http://www.utahgroup.com
On Thu, Nov 27, 2025 at 3:28 AM [email protected] <[email protected]>
wrote:
Hello everyone, I have used R:base to store all kinds of images
(BMP,PNG,JPG,ICO, etc)without a problem, but it seem that I missed out the
class on how to store and retrieve a PDF file.Is there anyone who has done that
(I imagine the answer is yes) and care to tell me what I'm doing wrong?Thank
you in advance for the help you can give me.Dr. Robert Rugilo
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/cc100161-466b-494f-9f37-bbfce51c8a10n%40googlegroups.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/CAOkDjxfNyampC-FByN85FTPisgu%2BU0uNMch0ZjV5TiyE69ZW-Q%40mail.gmail.com.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/475169385.71858.1764257140758%40mail.yahoo.com.
