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?

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?
>

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?
>

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?
>

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?
>>
>
>

Exactly what I was looking for!
Thanks to all!