Data Operations source elements
Data file operations manipulate the records in temporary output files that reside on the device. Temporary files can be used to store data while it is being collected until a specified task is complete.
A data set can contain records from a download, table, or function call.
Table operations affect records in user-defined tables that reside on the device. Tables are used during the process. The table operations use these table structures when adding, sorting, or deleting records in a specified table.
Beginning in 9.0 SP5, in Mobile Client for HTML5, a user can open multiple tabs in Mobile Client for HTML5. Changes to the local database are applied across all open tabs. For more information, refer to changesAbout parent and child tabs.
The following data operations source elements are available in Application Studio.
Download
A set of parameters used to request data from a specified database table. Refer to Add a Download element.
SQL Statement
Invokes SQL statements on the server. Refer to Add a SQL Statement element.
Replicate Local DB
Initializes database replication from within an app. Refer to Add a Replicate Local DB element.
Table Reference
References a table that has been defined outside an app. Refer to Add a Table Reference element.
Add Record To Table
Adds a record to a table. Refer to Add an Add Record to Table element.
Build Table
Builds an app table from a downloaded data source. Refer to Add a Build Table element.
Sort Table
Sorts the records in a table. Refer to Add a Sort Table element.
Clear Table
Clears an app table from a downloaded data source. Refer to Add a Clear Table element.
Update Record
Updates the current record in a data set at the device. Refer to Add an Update Record element.
Count Records
Counts the records in a data set at the device. Refer to Add a Count Records element.
Mark Record
Changes the record status in its database table during the upload process. Refer to Add a Mark Record element.
Next Record
Gets the next available record in a data set at the device. Refer to Add a Next Record element.
Seek Record
Finds records in a data set at the device. Refer to Add a Seek Record element
Select Table From List
Allows for temporarily populating a Mobile Client Table with selected records from a List View when the app is run in Mobile Client. Refer to Add a Select Table from List element.
Object Reference
Creates a reference to a registered web service API inbound data structure, or a Data Object. Refer to Add an Object Reference element.
Add to Object
Adds a data structure node to an object. Refer to Add an Add to Object element.
Object to Table
Moves all rows from a given level of the object to a Mobile Client table. Refer to Add a Clear Object element.
Clear Object
Clears all existing data from an object. Refer to Add a Clear Object element.
Export To CSV
Allows app users to export records from a record set to a CSV file. Refer to Add an Export to CSV element.
Import From CSV
Allows app users to import records from a CSV file to a Mobile Client table. Refer to Add an Import From CSV element.
Update Server Table
Allows a user to make an update directly to a middle-tier database table. Refer to About the Update Server Table element.
Loading...
There was a problem loading this topic