Alexandra Robin wrote:
I have a form that our "Document Control Engineer" uses to catalog documents stored on a server. I'm using a File Browse item to capture the path to the document, using the example of the Sample File Upload and Download packaged application as a guide. It works beautifully.. My table has these (and more) fields:
My (scaled down) report looks like the table below without the FILE_BLOB column. I don't need to display that column on the report, rather I have been asked by my boss to create a report that can be run that checks that the path is accurate. The form from which it is derived holds status and other information which I am thinking I can use to compare the BLOB link with where the document should actually be stored IF the user has completed the form correctly.
TABLE_ID DOWNLOAD ITEMNO ITEM_TITLE FILENAME MY FILE_BLOB COLUMN THAT I WANT TO DISPLAY AS TEXT 1000 Open AR-BIKE HOW TO RIDE A BIKE bikeRide.pdf \\myServer\myFolder\bideRide.pdf
As I type this I am wondering if there is another solution to this, possibly creating validations for each step on the form so the user has no chance of saving the form unless the link is created correctly.
Your expert suggestions are apty appreciated in advance!
You appear to have misunderstood how this actually works. The FILE_BLOB column contains the [complete] contents of the uploaded file, not a path reference to the original location. BLOB = Binary Large OBject, i.e. a container for unstructured (as far as the DB is concerned) raw data.
As I pointed out in your previous thread, for security and privacy reasons the original file path is completely unobtainable by the database through the file upload mechanism (except if using certain insecure configurations of Internet Explorer).