• Registered: 2014-09-06
  • Posts: 805

Topic: FILE

Hi all, I am confused. I have a record in a table that is should stores the Directory of the file (pdf or jpg ...)  and not the file in the database. I think when I store the file the database will be huge. What should I do for that and how can I show only the filename in the tablegrid ?

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,675

Re: FILE

Hi,
When you store anything as a 'linkfile', MVD automatically adds a field to your table called 'yourfieldname_filename'.  Please see the attached screenshot that shows how the 'linkfile' details are actually stored in the sqlite.db.
In the attached example, MVD automatically creates 'employeedetails_filename' (for the saved file) and 'photograph_filename' (for the saved image).  To show these filenames in a tablegrid, you can reference them using calculated fields (see attachment).
Derek.

Post's attachments

Attachment icon vpozidis.zip 504.1 kb, 253 downloads since 2020-10-10