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: 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: 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: 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: 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.

Abstract: A tab control includes a tab and a tab region including the tab. The tab region is capable of displaying one or more objects when the tab is activated.

Abstract: Techniques for providing a “cascade create” mechanism which allows data to be entered in related non-existing records in the database are disclosed. The techniques can be used to provide a database program that supports graphical, bi-directional data relationships, as well as multiple predicates. The “cascade create” mechanism supports arbitrary data relationships, as well as complex data models that are not supported by conventional techniques. Furthermore, the “cascade create” mechanism frees the users and database programmers from having to write code or provide rules that are specific to a particular data model and/or specific data relationship.