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 |