list can also be found in the Developer Help.
Property | Description |
Name | The Name of the data source is used when referencing the data source from code and also when setting the data source for a control in the design. |
Table | Sets the table used in the data source |
Index | Use this property to specify the sorting of the data. It affects the query that is created automatically. When no index hints are specified, the database management system locates an applicable access path. It is based on the information in the supplied query. The sort order for a form can be changed by a user by using the query dialog. |
CounterField | Use this property to specify a real field in the table that is used to save the sequence of the records. This option is used to let the user control the sequence of data. This field is usually called LineNum. |
AllowCheck | Specifies whether security checking occurs early, before the form opens. Yes – Before the form opens, check that the user has access to the form. A message is displayed if the form cannot open. Yes is the default, and is generally recommended. No – After the form opens, check whether the user has access to the form. If the user lacks access to the form, or to the underlying data sources, the form does not display any data. |
AllowEdit, AllowCreate, AllowDelete | These properties are used to reduce the access to data. You can only reduce the rights of the current user in relation to the general security system. Note that the AllowEdit also affects edit methods. You can also set this property individually on fields. |
StartPosition | This option specifies if the form sets the first or the last record active, when the form is opened. Only change this property when you have to as the user pays a performance penalty by finding the last record. |
AutoSearch, AutoNotify, AutoQuery | The properties specify whether the form:• Automatically creates a query (AutoQuery)• Performs the initial search (AutoSearch)• Notifies the system when the active record is changed (AutoNotify) This last option is necessary if other data sources are linked to this data source. |
Cross Company AutoQuery | Specifies whether the data source retrieves data from more than one company database. To specify which companies to search, the query.addCompanyRange(<company id>) method should be called before the query is executed. |
OnlyFetch Active | This option can be used to include a field list that only contains the fields displayed.NOTE: Be careful with this option if the data could be changed or used as parameter to method calls. Normally this option is only used in lookup form and for tables that contains large fields like containers. |
JoinSource | Use the LinkType to select whether the data source is joined to another data source. The joining of data is a mechanism which automatically limits the data in one data source to the data displayed in another data source (the controlling data source). This requires a relation between the two tables. An example is the SalesTable form that contains both Sales orders and lines. When a new sales order is selected the data source with the lines only shows the lines related to that sales order. |
LinkType | The LinkType property determines how two data sources are joined. The following list describes each option: • Passive: The query on the joined data source is only executed when the form is opened. A later change in the controlling data source does not change the view. • Delayed: The query on the joined data source is executed every time that the controlling data source is changed. The query execution is delayed to avoid the fetch of data, if the controlling data source is changed multiple times in a short time. This is the case when the user is scrolling through data on a grid. • Active: This option is similar to Delayed, except there is no delay before the query is executed. • InnerJoin: Selects records from the main table that have matching records in the joined table and vice versa. If the joined table does not have any records related to the main table record, the main table record is not displayed. Each match returns a result set of the main table record and joined table record joined together as one record. This is useful when wanting to display records from both tables in a grid. • OuterJoin: Selects records from the main table whether they have matching records in the joined table. Each match returns a result set of the main table record and joined table record joined together as one record. If there is no match, the fields from the joined table will be empty. • ExistsJoin: Selects a record from the main table only if there is a matching record in the joined table. As soon as a matching record is found, the main table record is returned. The record in the joined table is never retrieved. • NotExistsJoin: Select records from the main table that do not have a match in the joined table. HINT: Use the form tutorial tutorial_Form_Join to see the different results produced when you change the LinkType property. |
DelayActive | This enables you to delay the execution of the data source active method. If this property is set to Yes, the active method is activated only after a delay of 20 milliseconds. When a user scrolls through a data source, the active method is not called on every record, but only on the final record that the user selects |
InsertAtEnd, InsertIf Empty | These properties are used to specify whether the form automatically creates a new record in the following situations: • If the user browses past the last record in the data source (InsertAtEnd) • If the forms do not find any data (InsertIfEmpty) The new record is saved in the database only if the user changes any of the fields manually. The automatic creation of a new record in the two situations is similar to the event related to CTRL+N. |
Optional RecordMode | Specifies the create and delete behavior for records on an outer joined table. This can be set to one of the following options: • ImplicitCreate – When no record is saved in the database, create an outer joined record and joined tables as soon as the parent record becomes active. If the outer joined record or its children are not changed, they will be deleted when the parent record is no longer active. • ExplicitCreate – When no record is saved in the database, treat this record as disabled until the user explicitly triggers creation with the Optional Record checkbox. When the record exists, unchecking the checkbox will delete the record. • None – No special create or delete happens with an outer joined record. |
ValidTime StateAuto Query | Specifies the types of queries for date effectivity. (AsOfDate and DateRange) |
ValidTime StateUpdate | Specifies the types of updates for date effectivity. |
Best Regards,
Hossein Karimi
No comments:
Post a Comment