RecordDefn Class Properties

In this section, the RecordDefn class properties are described in alphabetical order.

Description

DataMover and SQR scripts use this property to order the build sequence of dependent views. This property is not used by the Build method when building a view.

The default value is 1.

This property is read/write.

Description

Use this property to specify a short description for a record.

This property is read/write.

Example

&myNewRecord.Description = "My new record";

Description

This property returns the total number of fields contained in the record. This value is a number.

This property is read-only.

Example

WinMessage("This record has this many fields : " | &REC.FieldCount);

Description

This property returns a multi-dimensional array of Any that contains the messages that occurred during execution of the Validate or Save methods. This array is only populated after the Validate or Save method has been executed.

The first dimension contains the message set number. The second dimension contains the message number. The third dimension contains the number of parameters in that message. The subsequent dimensions contain the values for the parameters. The maximum number of possible dimensions is 8.

This property is read-only.

Description

Use this property to specify the name of a record as a string value. Changing the name of a record and then saving it is equivalent to the rename operation. All references to the record by other managed objects will be updated as well.

This property is read/write.

Example

&myNewRecord.Name = "MYRECORD_VW";

Description

Use this property to specify a translate value from the OBJECTOWNERID field as a string value.

This property is read/write.

Description

Use this property to set or return a query security record if you want secure access to a record using a security view.

This property is read/write.

Description

This property sets or returns the related language record as a string. The value will be a null string ("") if there is no related language record.

This property is read/write.

Description

Use this property to determine whether this record definition was created using the RecordDefn class or not.

This property is read-only.

Description

Use this property to specify the set control field on the record definition.

This property is read/write.

Description

Use this property to specify the SQL for a view.

This property is read/write.

Example

&myNewRecord.SQL = "SELECT DISTINCT(PROCESS_INSTANCE) FROM PS_MESSAGE_LOG WHERE MESSAGE_NBR = 1018";

Description

Use this property to set the type for a record. The values can be one of the following. Value 4 with its associated constant value is deprecated, so it is not included in the list.

Numeric Value

Constant Value

0

%RecordType_SQLTable

1

%RecordType_SQLView

2

%RecordType_Derived

3

%RecordType_SubRecord

5

%RecordType_DynamicView

6

%RecordType_QueryView

7

%RecordType_TempTable

The default type is %RecordType_SQLView.

Example

&myNewRecord.Type = %RecordType_SQLTable;