Brilliant Database Software - Home
Database software - Online Help System

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

System Variables

table border="0" width="100%" cellspacing="0" cellpadding="4" bgcolor="#00000077">
System Variables

This section describes all system variables that can be defined in scripts.

Date and Time

  • [$_date] - returns the current system date;
  • [$_time] - returns the current system time;
  • [$_server time] - returns the system time on the server cmputer. Using this variable can be actual if users from different time zones use the database;
  • [$_timer] - returns the number of seconds elapsed since midnight (e.g. 834.12 or 51023.45).

Users and Groups

  • [$_user name] - returns the name of the user working with the database (see Users and Groups for more information);
  • [$_user group name] - returns the name of the group to which the user working with the database belongs (see Users and Groups for more information).
  • [$_users] - returns the list of all users in current database.

File paths

  • [$_software path] - contains the path to an executable file of the program without the ".exe" extension. For example, if the database is opened with the program residing in "C:\Program Files\DBApp v1\DB_App.exe", the variable will contain "C:\Program Files\DBApp v1\DB_App";
  • [$_database path] - contains the path to the current database, for example "C:\MyDocs\MyDB1.bbd";
  • [$_myfiles] - contains the path to the folder in which the database is located (for example, "C:\MyDocs"). If the SDK version of the program is used, this variable will contain the path to a special "myfiles" folder. Learn more....

Current Folder

  • [$_cur folder name] - returns the name of the current database folder, for example, "New Orders".
  • [$_cur folder path] - returns the path to the current folder. The value always starts with a word "Root", for example: "Root\All Orders\New Orders".
  • [$_cur folder id] - returns the system ID of the current folder, for example, 67 or 105. This ID can be used for explicit identification of the folder or for defining the folder in scripts. For example, in the Select Folder" or "Add Record (Folder, ...)" actions.
  • [$_parent folder id] - returns the ID of the parent folder (the folder in which the current folder is located).


  • [$_command line] - returns command line parameters with which the database was started. Learn more about supported parameters....
  • [$_rec write] - returns 1 if the current record can be accessed for writing; otherwise 0 is returned.
  • [$_main window] - returns 1 if the script was started from the main window of the program and 0 if the script was started from another window with the record (for example, if the record was opened in a new window from a relational field).
  • [$_hwnd] - returns HWND for a window that can process incoming WM_USER and WB_COPYDATA messages. More information is in the "SendMessage, WinAPI" section.

All topics in the "Variables" section: