Skip to content

File_Field_default_Value - DataDictionary

Sets the default value of a foreign table column without setting the DDO's Changed_State to True

Type: Property
Access: Write-Only
Data Type: String
Parameters: None

Parameters

Parameter Type Description
iFile Integer Number of the table in the current filelist
iField Integer Number of column iField in the table

Syntax

Property String File_Field_default_Value
Access Type Syntax
Write Access: Set File_Field_default_Value to StringVariable/Value

Description

File_Field_Default_Value sets a foreign column value without setting the DataDictionary object's (DDO's) Changed_State to True. This is used for defaulting values in new records.

Sample

This sample sets the default value of the Customer.Date column to 0/01/2008. Note that date values must be coded using U.S. date format.

Set File_Field_Default_Value File_Field Customer.Date to 01/01/2008

File and File_Field Interfaces

Many of the DataDictionary methods contain a two variants of the same message: Field_Message and File_Field_Message. For a complete description of these messages please refer to The Field and File_Field DD Interfaces.

The Field_ version of a message must use the keyword FIELD to identify the Table.Column name. The File_Field_ version must use the keyword FILE_FIELD to identify the Table.Column name. These should never be mixed!

// When using Field_ message use the FIELD keyword
Set Field_Default_Value Field Customer.Name to sValue

// When using the File_Field_ message use the FILE_FIELD keyword
Set File_Field_Default_Value of oCustomer_DD File_Field Customer.Name to sValue

See Also

Field_Default_Value | Field_Defaults