4D v11 SQL has added extra functionality to the Get 4D folder command.

In addtion to the 6 folder types available as parameters for the command in 4D 2004, the Get 4d folder command has 3 extra folder types and an optional * parameter in version 11.

In 4D 2004, the command had:

Constant	Type	Value
Active 4D Folder	Longint	0 (default)
Licenses Folder	Longint	1
Extras Folder	Longint	2
4D Client Database Folder	Longint	3
Database Folder	Longint	4
Database Folder Unix Syntax	Longint	5

In 4D v11 SQL, the following parameters were added:

Current Resources folder	Longint	6
Logs Folder	Longint	7
HTML Root Folder	Longint	8

Where:
Current Resources folder returns the Resources folder of the database.
Logs Folder returns the Logs folder of the database.
HTML Root Folder returns the current HTML root folder of the database.

The optional * parameter is used inside a component. It determines the database (host or component) for which you want to get the folder pathname. If the * parameter is passed, the command returns the pathname of the host database folder. Otherwise, it returns the pathname of the component folder. This parameter is only valid for Database Folder, Database Folder Unix Syntax and Current Resources folder folders. It is ignored in all other cases.