DataSplice Releases Mobile Integration Suite 3.0
Views - Data Tab
The Data tab contains the SQL statement and field list that defines what data (fields) will be included in the view.
| SQL Statement | Enter the SQL statement that will be used to access the database. While creating views for use with DataSplice, keep in mind that the first field in the SQL statement that is marked as searchable in the Fields tab is the field used as the default filter field in the DataSplice Remote Client application. |
|---|
Field List
The field list displays the fields (columns) of data returned from the SQL statement, along with the data type and precision. The remaining columns are defaulted to an initial set of values, but are changeable by the administrator.
| Field Name | The field name is the name of the field as it appears in the SQL statement or database table. This field is filled in by DataSplice. |
|---|---|
| Display Name | This is the name to display in the column header on the Remote Client. The display name provides a meaningful field name to the end user. To change a display name, double-click in the Display Name field and enter the new name. The display name may consist of any combination of numbers, letters, spaces, and special characters. |
| Primary Key | Checking this option makes the selected field part of DataSplice's primary key for this view. The primary key for each view is used to determine which, if any, records will be cached offline. Also, the primary key is used during insert, update, and delete events. |
| Conflict Check | The Conflict Check box indicates whether or not DataSplice should evaluate this field before attempting data modifications to see if a potential conflict exists. |
| Data Type | The Data Type field contains the type of data stored in the database. This field is filled in by DataSplice. |
| Precision | The Precision field displays the number of characters stored in the field as defined in the database, or returned by the ODBC driver. This field is filled in by DataSplice. |
