Media Data type

Version: Available or changed with runtime version 1.0.

Encapsulates media files, such as image .jpg and .png files, in application database tables. The Media data type can be used as a table field data type, but cannot be used as a variable or parameter. The Media data type enables you to import a media file to the application database and reference the file from records, making it possible to display the media file in the client user interface. You can also export media from the database to files and streams.

Static methods

The following methods are available on the Media data type.

Method name Description
FindOrphans() Discovers all orphaned media. Orphaned media is media that is not referenced by any other table.

Instance methods

The following methods are available on instances of the Media data type.

Method name Description
ExportFile(Text) Exports the media object (such as an image) that is currently used on record to a file on your computer or network. On the record, the media object is referenced in a Media data type field.
ExportStream(OutStream) Exports the current media object (such as a JPEG image) that is used on record to an OUTSTREAM object. The OUTSTREAM object can be created from a BLOB field, a FILE or from a .NET Framework interoperability object. In the record, the media is referenced in a Media data type field.
HasValue() Checks whether a Media data type field in a record has been initialized with a media object and that the specified media object exists in the database.
ImportFile(Text, Text [, Text]) Adds a media type, such as a JPEG image, from a file to a Media data type field of a record for displaying the media with the record in the client. The media file is imported to the application database, and a reference to the media is included in the Media data type field.
ImportStream(InStream, Text [, Text]) Adds a media type (MIME), such as jpeg image, from an InStream object to a Media data type field of a record for displaying the media in the client. The media file is imported to the application database and a reference to the media is included in the Media data type field.
ImportStream(InStream, Text, Text, Text) Adds a media type (MIME), such as jpeg image, from an InStream object to a Media data type field of a record for displaying the media in the client. The media file is imported to the application database and a reference to the media is included in the Media data type field.
MediaId() Gets the unique identifier of a media object on a record.

Note

Starting with Business Central 2021 release wave 1, when importing Microsoft Word files (.docx), macro packages (VBA code) will automatically be removed from the file when stored in the database. If macros are needed for end-user scenarios, the macro must be in the Word template (.dotx) associated with the document being imported.

Get Started with AL
Developing Extensions
Working With Media on Records