O$: Studio 5 store & display pdf files

[Bob Fiering]

Hi Jim,

I use postgresql and use there bytea, don’t know the field type on oracle 
When the user wants to open it externaly, i write the bytea to disk.

I open this on windows with:

Register DLL ("shell32.dll";"ShellExecuteW";"JJCCCCJ") 
Call DLL ("shell32.dll";"ShellExecuteW";0;"open”;Path_to_Document;" ";" ";1) 

I open this on mac with:

Calculate #F as $runapplescript(con('tell application "Finder" to open “';Path_to_document;'"'))

Regards,

Bob

> On 26 Mar 2015, at 15:51, Jim Pistrang <jim at jpcr.com> wrote:
> 
> Hi all,
> 
> Hope everyone is doing well.  Foggy gray day here, but the snow is melting!
> 
> I have a client-server app running in Studio 5 against an Oracle database.  The client is interested in storing and displaying PDF files, and I have a few questions I'm hoping someone can help with:
> 
> 1) Can I store PDF files in Oracle as a BLOB type?  If so, what do I need to do to insert and extract via a Studio interface?
> 
> 2) Can I display PDF files in an Omnis window?    If so, how?
> 
> 3) If I want Omnis to display a pdf file externally (Preview on a Mac, ??? on Windows) can I do this from Studio 5?  If so, what is the syntax?
> 
> Thanks,
> 
> Jim
> 
> --
> Jim Pistrang
> JP Computer Resources
> 413-256-4569
> <http://www.jpcr.com>
> 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com