Edit Collection Specification for Subcollection dialog box
Specify the properties of a subcollection.
Collection Source
Property | Description |
---|---|
Parent Collection | The name of the parent collection. |
Subcollection Property | The subcollection property as defined on the parent collection. |
Custom Load Method | A custom load method for loading data into the subcollection. This attribute should be specified only if the standard default method of loading the subcollection is inadequate. This is usually required only in very advanced applications. |
Method Parameters | Parameters passed to the custom load method. Parameters may include literal values, IDO properties, variables, or components. |
Base Table and Alias | The name of the primary table and its alias for the parent collection IDO. Read only. |
Read Mode | The isolation level for transactions when loading the collection. See the Read Mode property. |
Standard Operations
Property | Description |
---|---|
Navigate | The user may navigate to the first, next, previous, and last IDO items of the queried subcollection. |
Refresh | The user may requery data into the subcollection. |
Filter | The user may specify filter criteria for data queried into the subcollection grid. |
New/Copy | The user may create a new IDO item in the subcollection. |
Save | The user may save changes made to IDO items in the subcollection. |
Delete | The user may delete IDO items in the subcollection. |
Notes | The user may attach notes to IDO items in the subcollection. |
Spreadsheet Disabled | Does not apply to subcollections. |
Graph | The user may generate an ad hoc graph of data in the subcollection. |
Advanced Options
Property | Description |
---|---|
Record Cap Override | Specifies a record cap for the selected collection. This number cannot exceed the WinStudio maximum record cap, if it has been specified on the Process Defaults form. |
Operate as Primary | Unbound or variable-bound components are typically associated with the form's primary collection. For instance, variable-bound components are reinitialized when the user inserts a new IDO item in the primary collection. This option allows you to designate another collection or subcollection to be associated with these components. |
Reload after Save | Refresh the whole subcollection after a save. |
Reload after Child Save | Refresh the parent collection after the child subcollection is saved. |
Defer Refresh Until Visible | Do not populate the subcollection until it becomes visible to the user. This option is useful for cases in which subcollections or secondary collections are displayed on notebook tabs. If this property is specified, the collection is not queried until the user selects the tab that contains it. |
Save One Row Per Transaction | This option is not available for subcollections. When this option is applied to a top level collection, it affects both the top level collection and all subcollections. |
Load/Save Overrides | Specify custom procedures for update, insert, delete and post-query processing. |
Set LinkBy | Define the relationship between the parent collection and the child subcollection. This is usually specified as a set of IDO property pairs in which one property in each pair is from the parent collection and the other is from the subcollection. |
Subcollection Name and Filter Form
Property | Description |
---|---|
Collection Name | A string name or literal value that is used to identify the subcollection in error messages and menu options. This name should be appropriate for end users. |
Filter Form | The name of the form used to define ad hoc filter criteria for the subcollection. |
Selection Options
Property | Description |
---|---|
Filter | A permanent filter that is applied to the subcollection. Ad hoc filter specifications set by filter forms or Filter-in-Place are added to this filter when querying the subcollection. |
Distinct | Remove duplicate records from the returned data. If this option is checked, data cannot be reliably updated. It should only be used for read-only data. |
OrderBy | A comma-delimited list of IDO properties that are used to sort the collection. The default order is ascending. You can define the order of any of the properties by specifying either desc or asc following the IDO property name. |
GroupBy | A comma-delimited list of IDO properties that are passed to the IDO, which converts them to a SQL GROUP BY clause and passes them to the application database. |
How to Get There
To open this dialog box:
- Open a form that uses a subcollection.
- Go into Design Mode.
- Select the subcollection.
- In the Component property sheet, navigate to the Data Binding section.
- In the Binding field, click the ellipsis (...) button.
Related topics