File functions

This script function returns the value of the meta tags of different media files as text. The following file formats are supported: MP3, WMA, WMV, PNG and JPG. If the file filename does not exist, is not a supported file format or does not contain a meta tag named attributename, NULL will be returned.

Attribute(filename, attributename)

The ConnectString() function returns the name of the active data connection for ODBC or OLE DB connections. The function returns an empty string if no connect statement has been executed, or after a disconnect statement.

ConnectString()

The FileBaseName function returns a string containing the name of the table file currently being read, without path or extension.

FileBaseName()

The FileDir function returns a string containing the path to the directory of the table file currently being read.

FileDir()

The FileExtension function returns a string containing the extension of the table file currently being read.

FileExtension()

The FileName function returns a string containing the name of the table file currently being read, without path but including the extension.

FileName()

The FilePath function returns a string containing the full path to the table file currently being read.

FilePath()

The FileSize function returns an integer containing the size in bytes of the file filename or, if no filename is specified, of the table file currently being read.

FileSize()

The FileTime function returns a timestamp in UTC for the date and time of the last modification of the file filename. If no filename is specified, the function will refer to the currently read table file.

FileTime([ filename ])

The GetFolderPath function returns the value of the Microsoft Windows SHGetFolderPath function. This function takes as input the name of a Microsoft Windows folder and returns the full path of the folder.

GetFolderPath()

This script function returns the XML-header timestamp from a QVD file, if any is present, otherwise it returns NULL.  In the timestamp, time is provided in UTC.

QvdCreateTime(filename)

This script function returns the name of field number fieldno, if it exists in a QVD file (otherwise NULL).

QvdFieldName(filename , fieldno)

This script function returns the number of fields in a QVD file.

QvdNoOfFields(filename)

This script function returns the number of records currently in a QVD file.

QvdNoOfRecords(filename)

This script function returns the name of the table stored in a QVD file.

QvdTableName(filename)