pbAutoColumn - cDbCJGridPromptList
Determines if the prompt list should attempt to use the best column and index for the list
Type: Property
Access: Read/Write
Data Type: Boolean
Parameters: None
Syntax
Property Boolean pbAutoColumn
| Access Type | Syntax |
|---|---|
| Read Access: | Get pbAutoColumn to BooleanVariable |
| Write Access: | Set pbAutoColumn to BooleanVariable/Value |
Description
pbAutoColumn determines if the prompt list should automatically attempt to use the best column and index for seeding and displaying the data. Depending on your update mode (peUpdateMode) and piInitialColumn, this will do slightly different things.
Relational Prompt Lists
If your prompt list is relational (peUpdateMode is umPromptRelational), the grid will attempt to find the best column for this grid by calling SelectBestColumn. If a best column will be found, this column's ordering (ColumnOrdering) will be used to find your seeded data and will most likely be used as your initial column. This results in the prompt list popping up in the right column, with the right ordering, with the right seeded data. All of this is determined by the invoking object's binding data (e.g., Entry_Item).
piInitialColumn can change this behavior. If piInitialColumn is changed from its default of -1, the column specified will be used as the initial column and initial ordering. The initial seed will still use the index specified by the best column. Normally, piInitialColumn will be set to -1.
You almost always want pbAutoColumn to be true with relational prompt lists and this is the default.
Non Relational Prompt Lists
If your prompt list is not relational (peUpdateMode is not umPromptRelational), the grid will use the column specified in piUpdateColumn as the column to use for the auto column. This column will be will be used to find your seeded data and will most likely be used as your initial column. This results in the prompt list popping up in the specified column, with the right ordering and right seeded data for that column.
piInitialColumn can change this behavior. If piInitialColumn is changed from its default of -1, the column specified will be used as the initial column and initial ordering. The initial seed will still use the index specified by the best column. Normally, piInitialColumn will be set to -1.
If pbAutoColumn is set to false, you must specify the Ordering of the prompt list yourself.