| Parameter | Description |
|---|---|
| iField | Number of the column in the table |
Property Integer Field_Prompt_Object
| Read Access: | Get Field_Prompt_Object iField to IntegerVariable |
| Write Access: | Set Field_Prompt_Object iField to IntegerVariable/Value |
Field_Prompt_Object get/sets the object Id of the Prompt_Object for a table column, such as a lookup (selection) list. The Prompt_Object is the object that pops up when the kPrompt key (F4) is pressed.
Set Field_Prompt_Object Field Customer.Name to (Customer_sl(Self))
Lookup lists are created to provide an easy way to lookup records in your application. Typically, each table will have at least one lookup list associated with it. Columns in this lookup list will often consist of the most important columns in your table. These columns are often indexed and lookup lists are designed to let you easily search for records in any of these index orders.
You assign columns in a Data Dictionary to a lookup just be setting the Field_Prompt_Object property. Once assigned your windows applications will automatically attach those lookup lists to data entry objects (DEOs) that use that column.
You will want to create your lookup list objects before you assign them to a Field_Prompt_Object. You must know the name of the lookup list object before you assign it. Wizards are provided that allow you to create your lookup lists and assign them to the appropriate Data Dictionary columns in a single step.
If you are using one of the validation types (Field_CheckBox_Values, Field_Value_Range, Field_Value_Check or Field_Value_Table), the Data Dictionary is smart enough to be able to provide a default prompt list. It does this if there is no prompt list explicitly assigned. So if you assign a Field_Prompt_Object for a column, it will get used in place of the prompt list provided for extended validations.
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 Get Field_Prompt_Object Field Customer.Name to iPromptObject // When using the File_Field_ message use the FILE_FIELD keyword Get File_Field_Prompt_Object of oCustomer_DD File_Field Customer.Name to iPromptObjectSee Also
File_Field_Prompt_Object | Field_Zoom_Object | Defining Data Dictionary Field Attributes