Dear Mr. Karen, It was not stated clearly in my mail that we are storing the path only in the database table. It is new to me that It is possible to save a PDF in a table. I tried your command "SET VAR V_PDF_File VARBIT = ( ['C:\PDF\Report001.pdf'] )" . I faced the error in the screenshot below. Would you please suggest what additional requirements there are?
[image: f2f73a9d-a81d-46c6-aa38-cea796d8949a.png] Best regards, Dewan Monjoruzzaman Manager Software | Utah Group M: +8801916864347 W: http://www.utahgroup.com On Fri, Nov 28, 2025 at 2:40 AM 'Tony IJntema' via RBASE-L < [email protected]> wrote: > > Karen, > > It is possible to save a PDF in a table. > > The command is for instance: SET VAR V_PDF_File VARBIT = ( > ['C:\PDF\Report001.pdf'] ) > > The square brackets and quotes are important. > > Then you are able to insert the pdf itself in the table using this > variable, the column is also a varbit > > I agree it takes some space in de database, but the benefit is that you > are fully in control. > > Tony > Op 27-11-2025 om 20:44 schreef Tony Luck: > > That is correct, you need to set a variable that holds the path to the > pdf. On click will then open the pdf in the viewer. > > Regards > Tony > > On Fri, 28 Nov 2025, 1:25 am 'Karen Tellef' via RBASE-L, < > [email protected]> wrote: > >> 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 >> >> [image: image.png] >> >> >> Best regards, >> >> >> >> Dewan Monjoruzzaman >> >> Manager Software | 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 >> <https://groups.google.com/d/msgid/rbase-l/cc100161-466b-494f-9f37-bbfce51c8a10n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> >> -- >> 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 >> <https://groups.google.com/d/msgid/rbase-l/CAOkDjxfNyampC-FByN85FTPisgu%2BU0uNMch0ZjV5TiyE69ZW-Q%40mail.gmail.com?utm_medium=email&utm_source=footer> >> . >> -- >> 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 >> <https://groups.google.com/d/msgid/rbase-l/475169385.71858.1764257140758%40mail.yahoo.com?utm_medium=email&utm_source=footer> >> . >> > -- > 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/CABnhDARrLtiNFGGa95xx%3DAVQZ4UBFMJvUxEhB3EtbD-EjOaN7A%40mail.gmail.com > <https://groups.google.com/d/msgid/rbase-l/CABnhDARrLtiNFGGa95xx%3DAVQZ4UBFMJvUxEhB3EtbD-EjOaN7A%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > 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/ee67dd95-d6f6-47d7-b756-15edfe485469%40cio-bv.nl > <https://groups.google.com/d/msgid/rbase-l/ee67dd95-d6f6-47d7-b756-15edfe485469%40cio-bv.nl?utm_medium=email&utm_source=footer> > . > -- 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/CAOkDjxdaNbE7kKgnTWVC7NOVSOEO7bmAumwog4LuiQ7znwEDyw%40mail.gmail.com.
