<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="http://syndication.webwiz.co.uk/rss_namespace/">
 <channel>
  <title>Debenu Quick PDF Library - PDF SDK Community Forum : PDF from SQLite</title>
  <link>http://www.quickpdf.org/forum/</link>
  <description><![CDATA[This is an XML content feed of; Debenu Quick PDF Library - PDF SDK Community Forum : I need help - I can help : PDF from SQLite]]></description>
  <copyright>Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved.</copyright>
  <pubDate>Wed, 24 Jun 2026 15:38:02 +0000</pubDate>
  <lastBuildDate>Thu, 08 Apr 2021 11:47:56 +0000</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 11.01</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>www.quickpdf.org/forum/RSS_post_feed.asp?TID=3909</WebWizForums:feedURL>
  <image>
   <title><![CDATA[Debenu Quick PDF Library - PDF SDK Community Forum]]></title>
   <url>http://www.quickpdf.org/forum/forum_images/QPDF_Forum_Title.png</url>
   <link>http://www.quickpdf.org/forum/</link>
  </image>
  <item>
   <title><![CDATA[PDF from SQLite : Hi Vetal,Here you&amp;#039;ll find...]]></title>
   <link>http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15701.html#15701</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.quickpdf.org/forum/member_profile.asp?PF=111">Ingo</a><br /><strong>Subject:</strong> 3909<br /><strong>Posted:</strong> 08 Apr 21 at 11:47AM<br /><br /><div>Hi Vetal,</div><div><br></div><div>Here you'll find an older post having to do with SQLite. The posted code will give you few hints how to do:<br>http://www.quickpdf.org/forum/mac-loadfromstring-bug_topic3099_post12428.html?KW=SQLite+Blob#12428<br><br>Here's a larger sample with blobs from oracle:<br>http://www.quickpdf.org/forum/delphi-7-how-to-open-pdf-from-oracle-database_topic2653.html<br><br>If you don't need the DA-functions you shouldn't use them cause these functions are only a subset of the large bunch of functions and mixing DA- and normal functions should be avoided.<br><br>This is a good starting point to search in the QuickPDF-ressources:<br>https://www.debenu.com/docs/pdf_library_reference/Search.php<br><br>This is a good starting point to learn more about the library:<br>http://www.quickpdf.org/<br></div><div><br></div><div>Cheers and welcome here,</div><div>Ingo</div><div><br></div>]]>
   </description>
   <pubDate>Thu, 08 Apr 2021 11:47:56 +0000</pubDate>
   <guid isPermaLink="true">http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15701.html#15701</guid>
  </item> 
  <item>
   <title><![CDATA[PDF from SQLite : I would be surprised if your sample...]]></title>
   <link>http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15700.html#15700</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.quickpdf.org/forum/member_profile.asp?PF=1388">tfrost</a><br /><strong>Subject:</strong> 3909<br /><strong>Posted:</strong> 08 Apr 21 at 10:29AM<br /><br /><div>I would be surprised if your sample code even compiled, because DAOpenFromStream does not take a string as the first parameter. And QPDF has a 'golden rule' not to mix DA and non-DA functions, so if you actually need to use and modify the loaded file in QPDF you would need eventually to save it with DASaveAsFile to match a DA open function.</div><div><br></div><div>Your first question, how to save the file to a folder, is not really a QPDF issue. Unfortunately I am not familiar with the UniTable component (perhaps another user here is). But one suggestion would be to try to treat the data as TBytes (an array of bytes), and write that into a MemoryStream which you can SaveToFile, remembering to set the stream position back to 0 before you do. There may well be way get a stream more directly from the blob but you would find examples in your database documentation.</div><div><br></div><div>Your second question, how to load it into QPDF, is then simple: once you have the content in a stream, you can then use DAOpenFromStream. I would try to avoid using strings in this process, because this then starts to involve Unicode.</div><div><br></div>]]>
   </description>
   <pubDate>Thu, 08 Apr 2021 10:29:51 +0000</pubDate>
   <guid isPermaLink="true">http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15700.html#15700</guid>
  </item> 
  <item>
   <title><![CDATA[PDF from SQLite : Hello!the file is located in the...]]></title>
   <link>http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15699.html#15699</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.quickpdf.org/forum/member_profile.asp?PF=3266">vetal.kw</a><br /><strong>Subject:</strong> 3909<br /><strong>Posted:</strong> 08 Apr 21 at 7:13AM<br /><br /><div>Hello!</div><div>the file is located in the SQLite database (blob).</div><div>how do I save this file to a folder on my computer in Delphi?</div><div><br></div><div><div><font color="#00cc00">procedure TForm3.TabItem4Click(Sender: TObject);</font></div><div><font color="#00cc00">var</font></div><div><font color="#00cc00">&nbsp; QP: TDebenuPDFLibrary1811;</font></div><div><font color="#00cc00">begin</font></div><div><font color="#00cc00">QP:= TDebenuPDFLibrary1811.Create;</font></div><div><font color="#00cc00">try</font></div><div><font color="#00cc00">&nbsp; QP.UnlockKey('***************');</font></div><div><font color="#00cc00">&nbsp; QP.DAOpenFromStream(UniTable1.Fields&#091;2&#093;.asString,'');</font></div><div><font color="#00cc00">&nbsp;QP.SaveToFile('C:\test002.pdf');</font></div><div><font color="#00cc00">finally</font></div><div><font color="#00cc00">&nbsp; QP.Free;</font></div><div><font color="#00cc00">end;</font></div></div><div><font color="#00cc00"><br></font></div><div><font color="#ff0000">how can I specify a file from SQLite in "QP. DAOpenFromStream"?</font></div><div><font color="#00cc00"><br></font></div><div><font color="#00cc00"><br></font></div><div><font color="#00cc00"><br></font></div><div><font color="#00cc00"><br></font></div>]]>
   </description>
   <pubDate>Thu, 08 Apr 2021 07:13:48 +0000</pubDate>
   <guid isPermaLink="true">http://www.quickpdf.org/forum/pdf-from-sqlite_topic3909_post15699.html#15699</guid>
  </item> 
 </channel>
</rss>