Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Looking for advise |
Thu, Jan 5 2006 8:15 PM | Permanent Link |
Connie McBride | I want to somehow embed documents (non - text, source can be anything, including word docs, excel spreadsheets) into a blob field from
a file. Even more, I want to figure out how to properly display this. Is the even feasible. If so, how can I accomplish this? |
Thu, Jan 5 2006 9:44 PM | Permanent Link |
"Clive" | Firstly, you can store anything in a BLOB, even excel spreadsheets, word
docs etc. At runtime you would extract to a temp file and load with excel or word. "Connie McBride" <conniem@axcis.net> wrote in message news:176AFE60-DCD2-4A67-B6CB-C94413CE8E49@news.elevatesoft.com... >I want to somehow embed documents (non - text, source can be anything, >including word docs, excel spreadsheets) into a blob field from > a file. > Even more, I want to figure out how to properly display this. > Is the even feasible. > If so, how can I accomplish this? > |
Thu, Jan 5 2006 11:22 PM | Permanent Link |
Steve Forbes Team Elevate | Hi Connie,
Further to what Clive said, you will also need to persist the original name of the document, and restore and name the temp file with (at least) the file extension if you want to use winexec and the related file association to automatically use the correct editor/display application. Best regards Steve "Connie McBride" <conniem@axcis.net> wrote in message news:176AFE60-DCD2-4A67-B6CB-C94413CE8E49@news.elevatesoft.com... >I want to somehow embed documents (non - text, source can be anything, >including word docs, excel spreadsheets) into a blob field from > a file. > Even more, I want to figure out how to properly display this. > Is the even feasible. > If so, how can I accomplish this? > |
Fri, Jan 6 2006 12:53 AM | Permanent Link |
"Donat Hebert \(WSI\)" | Short snipet in case you need some code to store/open
store ... CurTable.Edit; TBlobField(CurTable.Fieldbyname('Document')).LoadFromFile(FileName); ... save the file extension ... CurTable.Post; open .. V_Tablename := 'Temp.' + V_Ext; TBlobField(CurTable.Fieldbyname('Document')).SaveToFile(V_Tablename); ShellExecute(handle, 'Open', Pchar(V_Tablename), '', '', SW_SHOWNORMAL); "Connie McBride" <conniem@axcis.net> wrote in message news:176AFE60-DCD2-4A67-B6CB-C94413CE8E49@news.elevatesoft.com... >I want to somehow embed documents (non - text, source can be anything, >including word docs, excel spreadsheets) into a blob field from > a file. > Even more, I want to figure out how to properly display this. > Is the even feasible. > If so, how can I accomplish this? > |
Fri, Jan 6 2006 2:54 AM | Permanent Link |
"GregF" | I would only add that instead of Temp.extension
you use TEMP + DATE + TIME . EXTENSION so as to avoid problems with multiple files being opened. gregF "Donat Hebert (WSI)" <dhebert@worldsoftwareinc.com> wrote in message news:DFFC28AE-3411-4EE1-B7DF-D8C132FB6CD3@news.elevatesoft.com... > Short snipet in case you need some code to store/open > > store ... > CurTable.Edit; > TBlobField(CurTable.Fieldbyname('Document')).LoadFromFile(FileName); > .. save the file extension ... > CurTable.Post; > > open .. > V_Tablename := 'Temp.' + V_Ext; > TBlobField(CurTable.Fieldbyname('Document')).SaveToFile(V_Tablename); > ShellExecute(handle, 'Open', Pchar(V_Tablename), '', '', SW_SHOWNORMAL); > > > "Connie McBride" <conniem@axcis.net> wrote in message news:176AFE60-DCD2-4A67-B6CB-C94413CE8E49@news.elevatesoft.com... >>I want to somehow embed documents (non - text, source can be anything, including word docs, excel spreadsheets) into a blob field >>from >> a file. >> Even more, I want to figure out how to properly display this. >> Is the even feasible. >> If so, how can I accomplish this? >> > > |
Mon, Jan 9 2006 1:18 PM | Permanent Link |
Connie McBride | Exactly what I was looking for!
Thanks to all! |
This web page was last updated on Sunday, May 5, 2024 at 07:30 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |