This section describes events in Brilliant Database for which scripts can be created, and specifies what predefined variables can be used in these events. For example, for the "On Edit" event the [$old_value] variable is available into which the value of the field before it was changed is written.
For a Form (Record)
Scripts for the form events are specified in the form properties on the "Scripts and Behaviour" tab.
On Record Select
This event is called right after the user passes to the record in the following cases:
This event is called when the user finishes editing the record (before changes are saved). This event allows you to perform data check.
Note: This event will be called only if the record has been changed.
On "Add" Action
Brilliant Database has a number of standard methods to create a new record not using scripts:
You can predefine these actions by specifying your script in the 'On "Add" Action' property - for example, to add preliminary data input.
For a Field
Scripts for field events are specified in the field properties on the "Scripts and Behaviour" tab.
This event is called when the user finishes editing a field. For example, if you have three fields [First Name], [Last Name] and [Full Name], for the [First Name] and [Last Name] you can specify a script in the "On Edit" event that will automatically update the value of the [Full Name] field.
On Left Button Click
This event is called at the left mouse click on the field. The event is available not for all types of fields.
On Right Button Click
This event is called at the right mouse click on the field. The event is available not for all types of fields.
On Double Click
This event is called at the double mouse click on the field. The event is available not for all types of fields.
On Enter Key
This event is called when the "Enter" key is pressed. The event is available for simple text fields.
On "Ins/Del" Key
This event allows you to predefine the standard action that will be called when the "Ins/Del" is pressed on the many-to-many relational field.
These events can be edited from the Script Editor ("Design DB->Edit Scripts..." menu).
On WinAPI SendMessage
This event is called when a message sent from another program by means of WinAPI SendMessage is received.
On Network SendMessage
This event is called when a message sent by means of Send Network Message is received from the database user.
Notification Button Click
This event is called when the user clicks the notification button in the notification area. To create a notification, use the Show Notification action.
Copyright (C) 2001-2010 Binary Brilliant Inc. All Rights Reserved.