Register
Sign In
| current date | The date recorded by the system clock (a date value). The year part is a two digit number. |
| current extended date | The date recorded by the system clock (a date value). The year part is a four digit number. |
| current time | The time recorded by the system dock (a time value). |
| current page number | In DataEase, this command is replaced by the Page Number applicationvariable. current page number is included only to maintain compatibility with applications created in character-based versions of DataEase. See DG 6 for information on creating application variables. |
| current Item number | The number of the current record. Records are automatically counted as they are processed by the procedure (a numeric value). |
current user name | The name used to sign onto the application (a text value). |
| current user level | The current user's security level (a numeric value from 1 to 7). |
current computername | The name of the workstation running the procedure when using DataEase in a multi-user environment (a text value set by the DENAME environmentvariable). |
| current status | The value of the processing action selected following the DQL input usingcommand or the status of the last DQL command that modifies data. By testing the current status variable, you can control subsequent processing following an input using command or check for errors following a DQL command that modifies data. See the input using command for an example of current status used with the input using command. |
Date, Exended Date, Time, Page Number, Item Number, User Name, User Level, Computername, Status
Example 1
Using current username to display a welcome message in a virtual field. The current user is Andy MacGrath
concat("Welcome to our application ", current username, " ;-)")
Result: Welcome to our application Andy MacGrath ;-)
Example 2
Using current user level to show or hide the secret field Customer Comments.
if (current user level = high, SetState("Customer Comments",1), SetState("Customer Comments",0))
Result: This will hide the field if the current user level is lower then High and show it if it is High.
Example 3
list records
current date ;
current user name .
for MEMBERS with TOTAL DUE > 175 ;
list records
LAST NAME in order ;
TOTAL DUE ;
current item number end
This script tells DataEase: (1) Select the MEMBERS records that have a TOTAL DUE value greater than $175, (2) list the LAST NAME and TOTAL DUE values and current item number (record number) from each record that is processed, and (3) list the current date (today's date) and the current user name (the name of the user who generated the report).
The output from this script might looks as follows:
Report generated by: George McGrath Date: 01/20/99
Item #
Last Name
Total Due
1
Perrault
215.00
2
Christino
280.00
3
Stafford
185.00
4
Strachan
205.00
See also commit, data-entry, exec SQL, global, input using, temp.
Variable component
Purpose
The current keyword lets you access any of the eleven system defined variables summarized below and on the following page.
Variables Used with the current Keyword
|
The date recorded by the system clock (a date value). The year part is a two digit number.
| |
|
Current extended date |
The date recorded by the system clock (a date value). The year part is a four digit number.
|
|
The time recorded by the system dock (a time value). | |
|
|
|
|
In DataEase, this command is replaced by the Page Number applicationvariable. current page number is included only to maintain compatibility with applications created in character-based versions of DataEase. See DG 6 for information on creating application variables. | |
|
|
|
|
The number of the current record. Records are automatically counted as they are processed by the procedure (a numeric value). | |
|
|
|
|
The name used to sign onto the application (a text value). | |
|
|
|
|
The current user's security level (a numeric value from 1 to 7). | |
|
|
|
|
The name of the workstation running the procedure when using DataEase in a multi-user environment (a text value set by the DENAME environmentvariable). | |
|
|
|
|
The value of the processing action selected following the DQL input usingcommand or the status of the last DQL command that modifies data. By testing the current status variable, you can control subsequent processing following an input using command or check for errors following a DQL command that modifies data. See the input using command for an example of current status used with the input using command. |
The following variables are used only in applications that access data on an SQL database:
|
The SQL Error Code number generated by the server when an error occurs during the processing of an SQL statement (e.g., CREATE, INSERT, UPDATE, or DELETE). current SQLCODE is set to zero if the last SQL statement is processed without error. Server-specific error codes are explained in your database engine documentation. See the commit andexec SQL commands for examples. | |
|
|
|
|
The number of rows processed by the procedure. See the exec SQLcommand for an example. | |
|
|
|
|
The SQL Message Text generated by the server, in addition to any errors and warnings (a server can return a current SQLCODE value of zero and still generate SQL Message Text). DataEase displays the first 50 characters of the message. Server-specific messages are explained in your database engine documentation. See the exec SQL command for an example. |
Note: See input using for examples demonstrating the use of the current status variable. See commit for examples that use current SQLCODE and current SQLCOUNT. See exec SQL for examples using current SQLCODE, current SQLCOUNT, and current SQLMSGTXT.
When current status is used with the input using command, it returns a numeric value from 1 to 4 depending on which menu selection (or icon) the user chooses after entering data.
When current status is used with an enter a record, modify records, delete records, or commit command, it returns 0 (zero) if the command is processed successfully and -1 (negative 1) if the command fails.
Syntax
current variable name
Example
list records
current date ;
current user name .
for MEMBERS with TOTAL DUE > 175 ;
TOTAL DUE ;
This script tells DataEase: (1) Select the MEMBERS records that have a TOTAL DUE value greater than $175, (2) list the LAST NAME and TOTAL DUE values and current item number (record number) from each record that is processed, and (3) list the current date (today's date) and the current user name (the name of the user who generated the report).
The output from this script might looks as follows:
Report generated by: George McGrath Date: 01/20/99
|
Item # |
Last Name |
Total Due |
|
1 |
Perrault |
215.00 |
|
2 |
Christino |
280.00 |
|
3 |
Stafford |
185.00 |
|
4 |
Strachan |
205.00 |
Product: Dataease [{8}]FIVE. Written by Graham Brown 02/02/14 at 10:50:34
Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 03/02/14 at 08:57:00
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 03/02/14 at 11:31:26
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 04/02/14 at 07:59:18
Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 04/02/14 at 10:04:40
Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 04/02/14 at 10:21:41
Product: Dataease [{8}]FIVE. Written by Graham Brown 05/02/14 at 14:58:33
Product: Dataease [{8}]FIVE. Written by Gregor Popp 28/08/14 at 06:18:53
Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 28/08/14 at 09:27:51
Product: Dataease [{8}]FIVE. Written by Gregor Popp 28/08/14 at 10:47:03
Product: Dataease [{8}]FIVE. Written by Simon B 28/08/14 at 11:22:12
Product: Dataease [{8}]FIVE. Written by George Washington 09/06/15 at 09:40:01
Product: Dataease [{8}]FIVE. Written by DataEase 10/06/15 at 07:37:46
Product: LegEasy 6 Windows. Written by KEV 09/09/15 at 13:26:31
Product: Dataease [{8}]FIVE. Written by Henry Gondorf 27/01/16 at 18:37:07
Product: Dataease [{8}]FIVE. Written by DataEase 27/01/16 at 20:13:36
Product: Dataease [{8}]FIVE. Written by Henry Gondorf 28/01/16 at 09:57:36
Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:06:23
Product: Dataease [{8}]FIVE. Written by afonso santos 13/06/16 at 22:44:45
Product: Dataease [{8}]FIVE. Written by DataEase 14/06/16 at 20:05:40
Product: . Written by Kelion Kopp 27/11/16 at 14:59:52
Product: . Written by Kelion Kopp 27/11/16 at 14:59:52
Product: Dataease [{8}]FIVE. Written by DataEase 28/11/16 at 12:59:26
Product: Dataease [{8}]FIVE. Written by Godfrey 26/01/17 at 12:52:01
Product: Dataease [{8}]FIVE. Written by DataEase 27/01/17 at 15:13:25
Product: Dataease [{8}]FIVE. Written by Karen Miller 18/04/17 at 14:44:07
Product: Dataease [{8}]FIVE. Written by DataEase 19/04/17 at 11:31:41
Product: Dataease [{8}]FIVE. Written by DataEase 20/04/17 at 15:08:30
Product: Dataease [{8}]FIVE. Written by Karen Miller 19/05/17 at 18:03:55
Product: Dataease [{8}]FIVE. Written by Josef Vella 22/05/17 at 09:46:22
Product: Dataease [{8}]FIVE. Written by Bolt-on-Trailers 13/10/17 at 21:36:01
Product: Dataease [{8}]FIVE. Written by DataEase 14/10/17 at 10:41:53
Product: Dataease [{8}]FIVE. Written by afonso santos 19/11/17 at 16:22:17
Product: DataEase 6.x. Written by joe peart 22/11/17 at 20:30:24
Product: DataEase 6.x. Written by afonso santos 23/11/17 at 00:03:02
Product: DataEase 6.x. Written by DataEase 23/11/17 at 13:18:05
Product: DataEase 6.x. Written by joe peart 24/11/17 at 10:54:05
Product: DataEase 6.x. Written by DataEase 24/11/17 at 10:55:24
Product: Dataease [{8}]FIVE. Written by afonso santos 27/11/17 at 00:09:26
Product: Dataease [{8}]FIVE. Written by DataEase 27/11/17 at 09:32:34
Product: Dataease [{8}]FIVE. Written by DataEase 09/03/18 at 18:06:01
Product: Not product specific.. Written by Paul Cheeseman 27/04/23 at 15:10:02
Product: Not product specific.. Written by Paul Cheeseman 27/04/23 at 15:40:46
Product: Not product specific.. Written by DataEase 27/04/23 at 17:26:04
Product: Dataease [{8}]FIVE. Written by DataEase 26/09/12 at 07:53:14
Product: Dataease [{8}]FIVE. Written by DataEase 14/03/13 at 11:21:26
Product: Dataease [{8}]FIVE. Written by DataEase 14/03/13 at 14:06:04
Product: Dataease [{8}]FIVE. Written by DataEase 17/09/13 at 07:42:10
Product: Dataease [{8}]FIVE. Written by DataEase 21/08/14 at 12:10:10
Product: Dataease [{8}]FIVE. Written by DataEase 25/08/14 at 18:17:03
Product: Dataease [{8}]FIVE. Written by DataEase 11/11/14 at 18:02:50
Product: Dataease [{8}]FIVE. Written by DataEase 19/11/14 at 16:15:24
Product: Dataease [{8}]FIVE. Written by DataEase 05/06/15 at 10:35:09
Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 15:00:10
Product: Dataease [{8}]FIVE. Written by DataEase 01/12/15 at 18:15:52
Product: Dataease [{8}]FIVE. Written by DataEase 08/01/16 at 14:24:52
Product: Dataease [{8}]FIVE. Written by DataEase 08/01/16 at 15:37:13
Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:26:05
Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 18:10:08
Product: Dataease [{8}]FIVE. Written by DataEase 08/09/16 at 11:07:37
Product: Dataease [{8}]FIVE. Written by DataEase 09/06/20 at 18:50:01
Copyright © DataEase Limited. All Rights Reserved
