For the most effective client-server implementation, disposition options may be assigned to individual queries. This facility provides the information needed to fine-tune the generated Access/DB2 front-end.
When the current database has been used first time with Scriptoria, the following dialog is displayed. In order for Scriptoria to determine what objects reference each query, it must search through all forms, reports, modules, and queries. By knowing the objects that reference queries, intelligent determinations can be made as to which queries needs to be updatable. Queries that do not require update capabilities can safely be replaced by equivalent pass-through queries, ensuring optimal client-server performance.
Scriptoria alerts the user that user the analysis may take some time and prompts for approval. Once object references are determined, the following form is displayed.
Query Type
Shows whether the query is a Selection or Action query.
Query NameName of the query.
DispositionOn initial entry, this field is set to the Selection and Action Global Default options specified on the Client-Server options page. Options that are changed persist after the form is closed and re-displayed on reentry. The options settings are initially the same as for the Global Default options. Changes to "Disposition" settings are persistent.
Press this button to display the adjacent query in design mode.
QueryDef References
Press the Refresh button to build (or rebuild) the QueryDef References work table. This process can take some, especially when the Search Modules box is checked. Note that searching through modules does not necessarily identify queries used for updates. It only searches for occurrences of the query name. A closer inspection is required to determine whether the query is used for updates.
After adding new queries or making references to existing queries, the object references should be refreshed. Existing disposition settings are retained.
The object types and names that reference the current query are shown in the following list box:
Double-click on an entry to display the Form, Report, or Module in design mode. This enables you to determine whether the query is used for updates. If it is updatable, then the "Disposition" should be set to either "Create new pass-through queries" or "Do not create pass-through queries". Conversely, set the "Disposition" to "Replace ODBC linked query with pass-through query" or "Rename original before replacing with pass-through query".
Resets the disposition for selection and action queries to their respective global defaults.
Selection QueryDefs that are referenced only by reports, or by forms that disallow edits, inserts and deletions, and those with no referencing objects are set to the "Replace Original QueryDef" option. This assumes that queries referenced by forms or VBA may need to be updatable. A closer manual inspection is recommended to determine whether update capability is actually required. When not, the more efficient pass-through query may be substituted for the corresponding linked QueryDef.
Note that Set Smart Options rebuilds the QueryDef References work table is rebuilt.