version 6.7 (Modified)
WR INSERT FIELD (area; table; field{; numFormat{; dateFormat{; timeFormat}}})
Parameter | Type | Description | |
area | Longint | 4D Write area | |
table | Integer | Table number | |
field | Integer | Field number | |
numFormat | String | Numeric format | |
dateFormat | Integer | Number of the date format | |
timeFormat | Integer | Number of the time format |
Description
The WR INSERT FIELD command inserts a reference to a field into area, replacing any selected text. The field is described by the table and field numbers. You can also specify the display format of inserted numeric, Date or Time fields.
The numFormat optional parameter indicates the format of numeric fields (i.e., Real, Integer, or Longint). It can contain any numeric display format, whether it exists or not (for example, "###,##"). Put an empty string when this parameter is not appropriate, or omit it if the following two parameters have been omitted.
The dateFormat optional parameter indicates the format of Date type fields. It must contain a number that indicates an existing date format. Put 0 when this parameter is not appropriate, or omit it if the following parameter has been omitted.
Following are the format codes for dates:
Date format | Name | Number |
1/6/00 | (Short) | 1 |
Thu, Jan 6 2000 | (Abbreviated) | 2 |
Thursday, January 6 2000 | (Long) | 3 |
01/06/2000 | (MM DD YYYY) | 4 |
January 6, 2000 | (Month Day Year) | 5 |
Jan 6, 2000 | (Abb Month Day) | 6 |
01/06/2000 | (MM DD YYYY Forced) | 7 |
The timeFormat optional parameter indicates the format of Time type fields. It must contain a number indicating an existing time format. Put 0 when this parameter is not appropriate or omit it.
Following are the format codes for times:
Time format | Number |
HH:MM:SS | 1 |
HH:MM | 2 |
HH hours MM minutes SS seconds | 3 |
HH hours MM minutes | 4 |
HH:MM AM PM | 5 |
See Also
WR GET REFERENCE, WR INSERT EXPRESSION.