
The message command tells DataEase to display a specified message. The message text can be 255 characters in length. You can tell DataEase to display the message on the status bar or in a standard Windows message box. Each message can be programmed to accept user input. DataEase provides five optional parameters (described below) that let you customize the message window.
Syntax
message "MESSAGE TEXT" [window | pause] [ "MESSAGE TITLE TEXT" ]; [Icon]; [Buttons]; [Beep] .
Usage
Message text can contain a field name, current system variable, a relational operator, a function, and/or a text constant enclosed in quotation marks. To divide the message into multiple lines, insert a vertical bar character (|) to indicate a new line (see Example 1). If you do not specify the window or pause parameter, DataEase displays the message on the status bar by default.
When you choose window, DataEase displays the message text in a standard Windows message box. DataEase automatically pauses and the user is required to press any key to acknowledge the message to resume processing. . Pause also displays a window, and is included for compatibility with previous versions of DataEase.
If you include the message title text parameter, DataEase displays the entered text on the message box title bar. If you exclude this parameter, DataEase displays DataEase Message as a default title.
To include the icon parameter, specify a number which represents one of the Windows icons shown in the table below.
Message Command Icon Parameters
Icon |
Numeric Value |
Icon Name |
|
1 |
Information Icon |
|
2 |
Exclamation Icon |
|
3 |
Stop Icon |
|
4 |
Question Icon |
If you exclude the icon parameter, DataEase automatically displays the Windows information icon by default.
To include the buttons parameter, specify a number which represents one of the button combinations shown in the table below.
Message Command Button Parameters
To display this button combination... |
...enter this number as the buttons parameter. |
OK, CANCEL |
1 |
RETRY, CANCEL |
2 |
ABORT, RETRY, IGNORE |
3 |
YES, NO |
4 |
YES, NO, CANCEL |
5 |
If you exclude the buttons parameter, DataEase displays the OK, CANCEL button combination by default.
When the user clicks a button displayed in the message box, DataEase returns a value to the current status system-defined variable. The current status values associated with each of the buttons are displayed in the table below.
Message Command Current Status Values
When you click this button... |
...DataEase Returns this valueto the current status variable. |
OK |
1 |
CANCEL |
2 |
ABORT |
3 |
RETRY |
4 |
IGNORE |
5 |
YES |
6 |
NO |
7 |
You can use the value stored in the current status variable to perform conditional processing of the remainder of your script as shown in Example 2.
To include an audible warning sound, specify a number which represents one of the standard Windows beep sounds, as shown in the table below.
Message Command Beep Parameters
To play the sound associated with this Windows icon... |
...enter this number. |
System Default |
1 |
Asterisk |
2 |
Information |
3 |
Exclamation |
4 |
Question |
5 |
Hand |
6 |
Stop |
7 |
OK |
8 |
If you exclude the beep parameter, DataEase does not provide a default.
When you choose pause, the message is displayed on the status bar. If you include any of the optional parameters with the pause option, DataEase displays an error when you choose Script>>Check DQL.
Example 1
message "Sorry. A high security level is
required|to run this procedure" window .
This message is displayed in a Windows message box. There are line breaks after the words Sorry and required. By default, DataEase includes the title DataEase Message, the Windows information icon, and the OK, CANCEL button combination.
Example 2
if EXPIRATION DATE < currentdate then
message jointext ( " Delete " , jointext
( LAST NAME , " record? " ) ) window " Delete
Inactive Member Records " ; 4; 5; 4.
if current status = 6 then-- Yes button
message " Record Deleted! " pause .
if current status = 7 then-- No button
message " Finding next record. " pause .
if current status = 2 then-- Cancel button
message " Cancelling procedure. " pause .
This example tells DataEase: (1) Process all the records in the MEMBERS table. (2) Check each record to see if the membership has expired as indicated by the EXPIRATION DATE. If the membership has lapsed, display the message: "Delete LAST NAME record?" in a message box that includes the mess
Product: Dataease [{8}]FIVE. Written by dtagcayman@yahoo.com 30/08/14 at 08:05:55
Product: Dataease [{8}]FIVE. Written by Josef Vella 31/08/14 at 15:30:29
Product: Dataease [{8}]FIVE. Written by dtagcayman@yahoo.com 01/09/14 at 03:56:36
Product: DataEase for Windows 7.x. Written by diego fernando Ocampo 09/09/14 at 16:04:21
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 01/10/14 at 11:19:35
Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup. 01/10/14 at 11:32:10
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 01/10/14 at 14:27:59
Product: Dataease [{8}]FIVE. Written by DataEase 01/10/14 at 15:15:04
Product: Dataease [{8}]FIVE. Written by Marco Marchesi 01/12/14 at 09:10:22
Product: Dataease [{8}]FIVE. Written by DataEase Development 01/12/14 at 18:31:59
Product: Dataease [{8}]FIVE. Written by Marco Marchesi 02/12/14 at 07:15:07
Product: Dataease [{8}]FIVE. Written by DataEase 02/12/14 at 08:31:21
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 30/01/15 at 16:15:02
Product: Dataease [{8}]FIVE. Written by DataEase 30/01/15 at 16:40:43
Product: Dataease [{8}]FIVE. Written by Francesco Toma 14/02/15 at 16:34:38
Product: Dataease [{8}]FIVE. Written by DataEase 15/02/15 at 12:59:05
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 16/02/15 at 01:19:28
Product: Dataease [{8}]FIVE. Written by DataEase 16/02/15 at 09:34:04
Product: Dataease [{8}]FIVE. Written by Wim 19/02/15 at 09:03:19
Product: Dataease [{8}]FIVE. Written by DataEase 19/02/15 at 09:06:21
Product: Dataease [{8}]FIVE. Written by Wim von der Becke 23/02/15 at 11:06:42
Product: Dataease [{8}]FIVE. Written by DataEase 23/02/15 at 11:18:40
Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 02/06/15 at 15:18:46
Product: Dataease [{8}]FIVE. Written by DataEase 03/06/15 at 08:06:29
Product: Dataease [{8}]FIVE. Written by Fatma Adel 05/11/15 at 17:30:42
Product: Dataease [{8}]FIVE. Written by DataEase 05/11/15 at 17:32:38
Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 15/06/16 at 13:06:42
Product: Dataease [{8}]FIVE. Written by peadar Kearney 26/02/19 at 13:57:27
Product: Dataease [{8}]FIVE. Written by DataEase 27/02/19 at 09:42:38
Product: Dataease [{8}]FIVE. Written by peadar Kearney 27/02/19 at 23:19:40
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 08/03/19 at 17:22:44
Product: Dataease [{8}]FIVE. Written by DataEase 12/03/19 at 15:09:48
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 14/03/19 at 12:09:50
Product: Dataease [{8}]FIVE. Written by Colleen Sienkiewicz 20/01/20 at 21:51:47
Product: Dataease [{8}]FIVE. Written by DataEase 21/01/20 at 11:45:37
Product: Dataease [{8}]FIVE. Written by DataEase 21/01/20 at 16:16:30
Product: Dataease [{8}]FIVE. Written by Colleen Sienkiewicz 21/01/20 at 17:00:00
Product: Dataease [{8}]FIVE. Written by DataEase 22/01/20 at 10:45:34
Product: Dataease [{8}]FIVE. Written by Colleen Sienkiewicz 07/09/21 at 13:43:01
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 08/09/21 at 17:34:31
Product: Dataease [{8}]FIVE. Written by afonso santos 12/12/21 at 11:23:50
Product: Dataease [{8}]FIVE. Written by afonso santos 12/12/21 at 11:34:38
Product: Dataease [{8}]FIVE. Written by Paul Cheeseman 15/12/21 at 13:15:31
Product: Dataease [{8}]FIVE. Written by Paul Cheeseman 15/12/21 at 13:23:45
Product: Dataease [{8}]FIVE. Written by Bonnie Clarke 18/02/22 at 16:07:10
Product: LegEasy 6 Windows. Written by Handles 17/03/22 at 11:24:09
Product: LegEasy 6 Windows. Written by Handles 17/03/22 at 13:51:59
Product: LegEasy 6 Windows. Written by Handles 25/03/22 at 20:18:15
Product: Dataease [{8}]FIVE. Written by DataEase 24/05/13 at 17:28:25
Product: Dataease [{8}]FIVE. Written by DataEase 08/08/16 at 11:36:42