It is recommended to use the File Manager component in FTP mode instead.
Sql to retrieve connections details.
This call is repeated (after processing the commands of the previous call) until it returns zero rows.
As a precaution it will also terminate if it finds the same same action and server columns as the last call in the resultset.
Possible value | Description |
---|---|
Download | Files will be downloaded. |
List | Retrieve list of files. |
Upload | Files will be uploaded. |
Possible value | Description |
---|---|
Active | Active transfer mode (PORT) will be used. |
Passive | Passive transfer mode (PASV) will be used. |
Possible value | Description |
---|---|
FTP | FTP (not encrypted). |
FTPS | FTP with TLS/SSL encryption (using the explicit method, if the server uses the implicit method or does not honor the request for encyption, then the component aborts the connection) |
Statement to extract information about files being transferred. Different resultsets are expected depending on if action is upload/download or if local source is disk/db.
Possible value | Description |
---|---|
Download | |
Upload |
Call made when a file is downloaded and no local file path is specified. If you specify a procedure column in the 'Download files' resultset that procedure will be used instead of the regular sql.
Possible value | Description |
---|---|
List | The file is being enumerated. (@file is not supplied) |
Allows you to validate the SQL parameters before any other SQL is run in the component. This call is only made if the SQL is a stored procedure and Validate parameters is checked.
Use this call to restrict which entries a user is allowed to view and edit, and to log which entries a user views.
Access to a menu item is normally controlled through functions and roles alone but some entities need more fine grained control. For example, a user may have access to the View Member menu item for normal members but not for members with a protected identity.
The menu items a user visits are always logged (in ADMINLogMenuItem) but for sensitive data you may need to log exactly what entries are viewed. Do the logging in this call as the common ways of viewing data (grid and InfoSQL) are not allowed to modify the database.
If you bind a scalar function instead of a stored procedure to this call then its name must end with '_GrantAccess'.