Original File Not Saved on Update Page

I have worked on this issue for hours and tried every solution I could find in the forums with no luck.

I have an insert record page and an update record page. The insert record page works perfect and the user can add a pdf file.

On the update record page the file is cleared from the database if the user does not upload a new file. I have tried binding to the field in the database as well as to a hidden form field that contains the name of the file. Either way the field is cleared. If I upload a new file it is uploaded and stored. The issue is only if I press update and do not upload a new file.

I have seen other posts with the same issue , but have not been able to find a resolution. Attached is my file. Thanks for your help.

In the update record behavior, you have bound to the Server Simple File Name variable, use the Server File Name variable instead.

I am having the same problem with the update form...but I have bound to the Server File Name. If I don't happen to update a file, it is deleted from the field.

Please post a copy of your page so i can examine the code.

I tested it on only a couple of fields, starting on line 800.

To retain the value in the database on update, you have to create a hidden form field for each file field, set the value of the hidden form field to get the value stored in the corresponding recordset column.


Then in the upload file server behavior, Bind the default file to the hidden form element.