Add low level text file support
It would be great if ADS server could add low level binary file support, the equivalent of:
FClose() - Closes a binary file.
FCreate() - Creates an empty binary file.
FErase() - Deletes a file from disk.
FDelete() - Deletes one or more files specified by a file mask and file attributes.
FOpen() - Opens a file on the operating system level.
FRead() - Reads characters from a binary file into a memory variable.
FReadStr() - Reads characters up to Chr(0) from a binary file.
FRename() - Renames a file.
FSeek() - Changes the position of the file pointer.
FWrite() - Writes data to an open binary file.
FCreate() - Creates and/or opens a binary file.
FReadLine() - Extracts the next line from a text file.
etc etc
Many applications use the above in addition to dbfs/adts used for main storage
peterk@quicksoftware.co.za
shared this idea
3 comments
-
joachimd
commented
to bypass File System rights checking ...
-
srwhite
commented
Why should these functions be part of the Database Server? They sound like functions that should be part of the language you use to develop your application.
-
joachimd
commented
IIRC SQL Any supports selecting from the file system. Would that be enough?
e.g. SELECT * FROM filesystem.files WHERE directory='C:\' AND filename = 'autoexec.nt'
returning such columns like: directory, filename, filedate, attributes, file content, ...
