I'm using apex 4.2.
Say I have a table with a blob column that will hold PDF, Word, Excel, or image.
Additionally some text columns ID's descriptions.
I'd like to have users search my table, using the descriptions, and once some records were found....have a button? a link? something that allows them to "open" the document (not necessarily download it).
Obviously the user would need to have Word or Excel.
Everything I've found seems geared to downloading a file, then going and opening it.
Is it possible to simply open the object (from APEX) in its native tool, and NOT save it?
I figured I'd find a "recipe" on the web for this simple use case, but have not had any luck.
Maybe someone can point me there or has a better idea.
Should I try to run a process that converts ALL documents to HTML and then store that?
Does that help me to display it without downloading a file?
My experience with APEX is limited, and my web experience is minimal.
Thanks.