O$: Studio 5 store & display pdf files

Bob Fiering bob at maxolution.nl
Thu Mar 26 10:57:45 EDT 2015

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;'"'))



> 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

More information about the omnisdev-en mailing list