This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

 
4D v20 R8
Information page

Information page  


 

 

The “Information” page provides information about the 4D and system environments, as well as the database and application files. Each page can be displayed using tab controls at the top of the window.

Program  

This page indicates the name, version and location of the application as well as the active 4D folder (for more information about the active 4D folder, refer to the description of the command in the SET LIST ITEM ICON manual). 

The central part of the window indicates the name and location of the database structure and data files as well as the log file (if any). The lower part of the window indicates the name of the 4D license holder, the type of license, and the name of the database user when passwords have been activated (or Designer if this is not the case).

  • Display and selection of pathnames: On the Program page, pathnames are displayed in pop-up menus containing the folder sequence as found on the disk:

    If you select a menu item (disk or folder), it is displayed in a new system window.
    The Copy the path command copies the complete pathname as text to the clipboard, using the separators of the current platform.
  • “Licenses” Folder
    The “Licenses” Folder button displays the contents of the active Licenses folder in a new system window. All the license files installed in your 4D environment are grouped together in this folder, on your hard disk. When they are opened with a Web browser, these files display information concerning the licenses they contain and their characteristics.
    The location of the "Licenses" folder can vary depending on the version or language of your operating system. For more information about the location of this folder, refer to the command.
    Note: You can also access this folder from the “Update License” dialog box (available in the Help menu).
    When you click on the “Licenses” Folder button, 4D opens the Licenses folder in a standard system window. If you have activated your 4D application, the folder must contain at least one license file (file in html format). If you have activated several products, plug-ins or extensions, the folder will contain several license files.

Tables  

This page provides an overview of the tables in your database: 

The page lists all the tables of the database (including invisible tables) as well as their characteristics:

  • ID: Internal number of the table.
  • Name: Name of the table. Names of deleted tables are displayed with parenthesis (if they are still in the trash).
  • Records: Total number of records in the table. If a record is damaged or cannot be read, Error is displayed instead of the number. In this case, you can consider using the verify and repair tools.
  • Fields: Number of fields in the table. Invisible fields are counted, however, deleted fields are not counted.
  • Indexes: Number of indexes of any kind in the table
  • Encryptable: If checked, the Encryptable attribute is selected for the table at the structure level (see Encryptable). 
  • Encrypted: If checked, the records of the table are encrypted in the data file.
    Note: Any inconstency between Encryptable and Encrypted options requires that you check the encryption status of the data file in the Encrypt page of the database. 
  • Address Table Size: Size of the address table for each table. The address table is an internal table which stores one element per record created in the table. It actually links records to their physical address. For performance reasons, it is not resized when records are deleted, thus its size can be different from the current number of records in the table. If this difference is significant, a data compacting operation with the "Compact address table" option checked can be executed to optimize the address table size (see Compact page).
    Note: Differences between address table size and record number can also result from an incident during the cache flush.

Note: Information on this page is available in both standard and maintenance modes.

The Data and Structure pages provide information about the available and used storage space in the database structure and data files. 

Notes:

  • These pages cannot be accessed in maintenance mode.
  • The Data page does not take into account any data that may be stored outside of the data file (see External data storage).
  • The Structure page is only available in the 4D and 4D Server applications.

This information is provided in graph form:

Files that are too fragmented reduce disk, and thus, database performance. If the occupation rate is too low, 4D will indicate this by a warning icon (which is displayed on the Information button and on the tab of the corresponding file type) and specify that compacting is necessary:

A warning icon is also displayed on the button of the Compact page:

 
PROPERTIES 

Product: 4D
Theme: Maintenance and security center

 
PAGE CONTENTS 
 
HISTORY 

Modified: 4D v16 R2
Modified: 4D v17 R5

 
ARTICLE USAGE

4D Design Reference ( 4D v20 R8)