ODBC Driver for FTP

Build 20.0.7587

Root

The root table. This table will always be available. Other tables are automatically detected by the TableDepth connection property.

Table Specific Information

Select

Retrieve all files and directories inside a directory.

SELECT * FROM Root

Insert

To upload a file to the server you need to specify LocalFile and a Filename.

INSERT INTO Root(Localfile,Filename) VALUES ('D:\\\\ShareFolder\\\\Notes.txt','NewNotes.txt')

To create a new directory on the server you need to specify Filename and set IsDirectory to true.

INSERT INTO Root(Filename,IsDirectory) VALUES ('New Directory',true)

Update

Only the name of a file can be updated and FilePath must be specified in the WHERE clause.

UPDATE Root SET Filename='OldNotes.txt' WHERE FilePath='/Documents/Test/NewNotes.txt'

Delete

Delete a file by providing the FilePath.

DELETE FROM Root WHERE FilePath='/Documents/Test/OldNotes.txt'

Delete a directory by providing the FilePath and set IsDirectory to true.

DELETE FROM Root WHERE FilePath='/Documents/Test' AND IsDirectory=true

Columns

Name Type ReadOnly Description
FilePath [KEY] String True

The current path in the FTP/SFTP server.

Filename String False

The name of the file or directory.

FileSize Long True

The size of the file. 0 in case of a directory.

LastModified Datetime True

The last modification time of the file.

IsDirectory Boolean True

The file name of the attachment.

LocalFile String True

The path of a file to upload. This column is used for insert statements only.

Permissions String True

Permissions of a directory or a file.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587