This topic is locked

Document upload

12/10/2007 11:51:24 AM
ASPRunnerPro General questions
I
ICDB author

Is there a limit of one document (say WORD) upload to a record?
The user uploads a document and it apprars on the form BUT when the user attempts to upload a second doc, the first (original) doc is replaced by the second doc.
Is this a "feature" or is it a failure on my design/options/setup/etc.
Also, The ability to hyperlink documents (as discussed on the forum) is of great interest!
Thanks

stanl 12/10/2007

Is there a limit of one document (say WORD) upload to a record?

The user uploads a document and it apprars on the form BUT when the user attempts to upload a second doc, the first (original) doc is replaced by the second doc.
Is this a "feature" or is it a failure on my design/options/setup/etc.
Also, The ability to hyperlink documents (as discussed on the forum) is of great interest!
Thanks


You would either have to create several fields for the uploads (i.e. file1, file2, etc.) or the better way would be to create a master detail where you can add as many as needed. This last method would require you to create a separate table for the uploads and link them to the master record with masterID. As long as you create the separate field for the file name, it will be hyperlinked.
Under formatting there are two options for files:
Database file - choose this type if you use this field to hold binary files. This Edit type allows you upload binary files to the database.
Document upload - use this format if you like to upload files to folder on the webserver.
Hope this helps.

I
ICDB author 12/10/2007



You would either have to create several fields for the uploads (i.e. file1, file2, etc.) or the better way would be to create a master detail where you can add as many as needed. This last method would require you to create a separate table for the uploads and link them to the master record with masterID. As long as you create the separate field for the file name, it will be hyperlinked.
Under formatting there are two options for files:
Database file - choose this type if you use this field to hold binary files. This Edit type allows you upload binary files to the database.
Document upload - use this format if you like to upload files to folder on the webserver.
Hope this helps.


Question answered, thanks.