SQL Eval Function File

Provides methods for the creation, copying, deletion, moving, and opening of a single file.

Name Description Example
File_AppendAllText(path, content) Appends the specified stringto the file, creating the file if it does not already exist. Try it
File_Copy(sourceFileName, destFileName, overwrite) Copies an existing file to a new file. Try it
File_Create(path) Creates or overwrites a file in the specified path. Try it
File_Decrypt(path) Decrypts a file that was encrypted by the current account using the File_Encrypt procedure. Try it
File_Delete(path) Deletes the specified file. Try it
File_Encrypt(path) Encrypts a file so that only the account used to encrypt the file can decrypt it. Try it
File_GetCreationTime(path) Returns the creation date and time of the specified file or directory. Try it
File_GetCreationTimeUtc(path) Returns the creation date and time, in coordinated universal time (UTC), of the specified file or directory. Try it
File_GetLastAccessTime(path) Returns the date and time the specified file or directory was last accessed. Try it
File_GetLastAccessTimeUtc(path) Returns the date and time, in coordinated universal time (UTC), that the specified file or directory was last accessed. Try it
File_GetLastWriteTime(path) Returns the date and time the specified file or directory was last written to. Try it
File_GetLastWriteTimeUtc(path) Returns the date and time, in coordinated universal time (UTC), that the specified file or directory was last written to. Try it
File_IsExists(path) Determines whether the specified file exists. Try it
File_Move(sourceFileName, destFileName) Moves a specified file to a new location, providing the option to specify a new file name. Try it
File_ReadAllText(path) Opens a text file, reads and returns all the text in the file, and then closes the file. Try it
File_Replace(sourceFileName, destFileName, destBackupFileName, ignoreMetadataErrors) Replaces the contents of a specified file with the contents of another file, deleting the original file, and creating a backup of the replaced file and optionally ignores merge errors. Try it
File_SetCreationTime(path, creationTime) Sets the date and time the file was created. Try it
File_SetCreationTimeUtc(path, creationTime) Sets the date and time, in coordinated universal time (UTC), that the file was created. Try it
File_SetLastAccessTime(path, lastAccessTime) Sets the date and time the file was created. Try it
File_SetLastAccessTimeUtc(path, lastAccessTime) Sets the date and time, in coordinated universal time (UTC), that the specified file was last accessed. Try it
File_SetLastWriteTime(path, lastWriteTime) Sets the date and time that the specified file was last written to. Try it
File_SetLastWriteTimeUtc(path, lastWriteTime) Sets the date and time, in coordinated universal time (UTC), that the specified file was last written to. Try it
File_WriteAllText(path, contents) Creates a new file, write the contents to the file, and then closes the file. If the target file already exists, it is overwritten. Try it