One feature of Maintainers is to allow the uploading of files from your client machine to the server. This feature is unique in the fact that it will also add a record to the database, as well as upload the specific file to the server.
To begin, create a maintenance application as you normally would. In “Field Settings”, change the dropdown box from “Basic field attributes” to “Form input attributes.”
Find the field that will serve as the File Name for the uploaded file. In the “User Def” column, select the “U”. This will tell m-Power to create an upload button next to this field and when the record is written to the table, write the File Name to this field.
Before running the application, let’s look at the application properties for this program. After you scroll to the bottom, you will see these three options:
File Upload Directory — The location on the m-Power server where this file will be uploaded. If the folder does not exist, it will be created.
File Upload Max Size — The maximum size, in megabytes, that a file can be in order to be uploaded. If a file is too large, the user will see an error at runtime that they must pick a smaller file.
File Upload Auto Rename — Allows you to control the behavior when a file of the same name already exists in the upload directory. You can either choose to have m-Power auto-rename the file (so file.txt would become file(1).txt) or you can automatically overwrite the existing file.
Make any necessary changes and click “OK”.
When I run my application, I see something like this:
Notice the “Browse” button in the Attachment cell. Clicking on “Browse” brings up a view of my local machine. After I select a file, the location will be inserted.
Below is a list of the common error checking that m-Power will do to ensure that the proper information is being uploaded:
If the file name is too long, this error is displayed:
If a file exceeds the maximum size, this error is displayed:
Editor’s Note: The Maximum Size was changed in this example for practicality purposes. The default size is 100 MB.