Abstract: An apparatus and method for an inspection apparatus for inspecting a component. The inspection apparatus including a robotic arm. A micro-XRF instrument having an instrument head coupled to the robotic arm. A seat supporting the component within a scanning area during inspection; and a computer in communication with the robotic arm and the micro-XRF instrument.

Abstract: A computer-implemented method for contextually displaying saved search queries is disclosed. The method comprises: displaying a user interface comprising a layout, the layout being associated with one or more tables in a database; receiving from the user interface a request for stored search queries; upon receiving the request, identifying a plurality of stored search queries, each of the plurality of stored search query being associated with one or more tables in the database; and displaying a stored search query from the plurality of stored search queries if the one or more tables associated with the stored search query and the one or more tables associated with the layout include at least one table in common.

Abstract: Methods, program products, and systems for displaying context-aware charts are described. In context-aware charts, content of a chart can reflect a context of the chart. A charting object can be defined using a data series. The system can dynamically determine what subset of a data source should be used for the data series, depending on where the chart object is placed in a layout, form or other display area. Therefore, a single chart definition can be used to display various charts based on the context of the chart. When a chart object is moved from one data area to a new data area, the system can change the source of the data series such that the data series of the chart corresponds to a different subset of the data source.

Abstract: Methods, program products, and systems of maintaining data states upon forced exit are disclosed. In one aspect, an application program executing on the mobile device can maintain a connection to a remote data store and retrieve and cache data from the data store. When the mobile device receives an event that forces the application program to terminate, the mobile device can provide a time window in which the mobile device can perform various state preservation actions. During the time window, the mobile device can store data states, including states of the connection and states of the cached data. When the application program is re-launched, the mobile device can use the stored data states to restore a connection and a displayed view.

Abstract: Methods, program products, and systems for automatically searching data in multiple data fields are described. A user can view data retrieved from a database and formatted based on a layout. While viewing the data, the user can perform a search using one or more search terms. A system can automatically examine the database and identify on which tables and on which data fields of the tables to perform the search. The system can identify searchable tables and data fields by analyzing the database schema as well as characteristics of the tables and data fields.

Abstract: Methods, program products, and systems for displaying data in formatted views using reference files are described. In some implementations, a database application program can generate a result set using one or more queries. The result set can contain actual data from a database and metadata. The metadata can contain references to data records in the database, the references can include identifiers that can identify the data records. When a user saves a database report file, the user can save at least a part of the result set using the identifiers instead of the queries and layouts. Thus, the result set can be saved as a reference file. When the database application program opens the saved reference file, the database application program can reproduce the result set using the stored references without running all of the queries.

Abstract: Methods, program products, and systems of maintaining data states upon forced exit are disclosed. In one aspect, an application program executing on the mobile device can maintain a connection to a remote data store and retrieve and cache data from the data store. When the mobile device receives an event that forces the application program to terminate, the mobile device can provide a time window in which the mobile device can perform various state preservation actions. During the time window, the mobile device can store data states, including states of the connection and states of the cached data. When the application program is re-launched, the mobile device can use the stored data states to restore a connection and a displayed view.

Abstract: A system displays content from a database in a formatted view. The formatted view includes one or more data fields arranged in one or more data sections. Each of the data sections includes a sub-summary display field. The system receives a request to modify data in one of the data fields. In response, the system reformats the formatted view. The reformatting includes moving the data field from a first data section to a second data section and updating the sub-summary display field in the first data section and the sub-summary display field in the second data section. The system displays the reformatted view.

Abstract: A graphical user interface in a database application includes a control for manipulating a result set of a query. The control is operable to display multiple graphical representations of a result ratio between a total number of rows in a database table returned in response to the query and a total number of rows of the database table. By interacting with the control, the user can switch (e.g., toggle) between graphical representations of the result ratio. The toggling can be achieved by automatically creating supplemental queries to the database. The graphical representations can be a pie chart, bar chart, eye chart or any other graphical representation that is suitable for displaying the result ratio.

Abstract: Methods, program products, and systems of maintaining data states upon forced exit are disclosed. In one aspect, an application program executing on the mobile device can maintain a connection to a remote data store and retrieve and cache data from the data store. When the mobile device receives an event that forces the application program to terminate, the mobile device can provide a time window in which the mobile device can perform various state preservation actions. During the time window, the mobile device can store data states, including states of the connection and states of the cached data. When the application program is re-launched, the mobile device can use the stored data states to restore a connection and a displayed view.

Abstract: Methods, program products, and systems of chunking data records are described. In general, in one aspect, a mobile device can provide for display on a display screen a scrollable window. The scrollable window can display first display content (e.g., a first segment of formatted data) stored in a first display buffer. The mobile device can determine that the scrollable window will cross a boundary of the first display buffer. Upon the determining, the mobile device can create second display content (e.g., a second segment of formatted data) in a second display buffer. The second display content can include display content that borders the first display content at the boundary. The mobile device can provide for display the second display content when the scrollable window crosses the boundary.

Abstract: Methods, program products, and systems for automatically searching data in multiple data fields are described. A user can view data retrieved from a database and formatted based on a layout. While viewing the data, the user can perform a search using one or more search terms. A system can automatically examine the database and identify on which tables and on which data fields of the tables to perform the search. The system can identify searchable tables and data fields by analyzing the database schema as well as characteristics of the tables and data fields.

Abstract: Methods, program products, and systems of maintaining data states upon forced exit are disclosed. In one aspect, an application program executing on the mobile device can maintain a connection to a remote data store and retrieve and cache data from the data store. When the mobile device receives an event that forces the application program to terminate, the mobile device can provide a time window in which the mobile device can perform various state preservation actions. During the time window, the mobile device can store data states, including states of the connection and states of the cached data. When the application program is re-launched, the mobile device can use the stored data states to restore a connection and a displayed view.

Abstract: Methods, program products, and systems of chunking data records are described. In general, in one aspect, a mobile device can provide for display on a display screen a scrollable window. The scrollable window can display first display content (e.g., a first segment of formatted data) stored in a first display buffer. The mobile device can determine that the scrollable window will cross a boundary of the first display buffer. Upon the determining, the mobile device can create second display content (e.g., a second segment of formatted data) in a second display buffer. The second display content can include display content that borders the first display content at the boundary. The mobile device can provide for display the second display content when the scrollable window crosses the boundary.

Abstract: Techniques for providing limited access to data stored in records of databases are disclosed. The techniques can be implemented in a database program operating on a computer system. The database program can provide a Graphical User Interface that can be used to conveniently define calculation expressions that limit operations on the records of the database. The calculation expression can be defined for a user or group of users with respect to a particular operation that can be requested to be performed on the records of the database. The calculation expression can be defined based on fields of the records, as well as other information, for example, various state variables of the database (e.g., date, time, number of records, etc.) The calculation expression can, in turn, be evaluated with respect to each record to determine whether a request to perform an operation on that particular record should be granted or denied.

Abstract: Methods, program products, and systems for displaying context-aware charts are described. In context-aware charts, content of a chart can reflect a context of the chart. A charting object can be defined using a data series. The system can dynamically determine what subset of a data source should be used for the data series, depending on where the chart object is placed in a layout, form or other display area. Therefore, a single chart definition can be used to display various charts based on the context of the chart. When a chart object is moved from one data area to a new data area, the system can change the source of the data series such that the data series of the chart corresponds to a different subset of the data source.

Abstract: Methods, program products, and systems for displaying data in formatted views using reference files are described. In some implementations, a database application program can generate a result set using one or more queries. The result set can contain actual data from a database and metadata. The metadata can contain references to data records in the database, the references can include identifiers that can identify the data records. When a user saves a database report file, the user can save at least a part of the result set using the identifiers instead of the queries and layouts. Thus, the result set can be saved as a reference file. When the database application program opens the saved reference file, the database application program can reproduce the result set using the stored references without running all of the queries.

Abstract: Methods, program products, and systems for automatically searching data in multiple data fields are described. A user can view data retrieved from a database and formatted based on a layout. While viewing the data, the user can perform a search using one or more search terms. A system can automatically examine the database and identify on which tables and on which data fields of the tables to perform the search. The system can identify searchable tables and data fields by analyzing the database schema as well as characteristics of the tables and data fields.

Abstract: A system displays content from a database in a formatted view. The formatted view includes one or more data fields arranged in one or more data sections. Each of the data sections includes a sub-summary display field. The system receives a request to modify data in one of the data fields. In response, the system reformats the formatted view. The reformatting includes moving the data field from a first data section to a second data section and updating the sub-summary display field in the first data section and the sub-summary display field in the second data section. The system displays the reformatted view.

Abstract: A setup dialog for a web viewer dynamically changes to reflect parameters needed to generate a web address. The setup dialog can include a list box containing websites for which website templates are available for assisting the user in generating web addresses. The list box can also include an option to generate a custom web address without using a website template. An extensible grammar is provided for generating custom website templates.