Examples: Toolbars
- This toolbar button formula opens the names.nsf database on the doc server to the People view:
@Command([FileOpenDatabase]; "DOC" : "NAMES.NSF"; "People")
- This toolbar button formula presents the user with the list of databases in a database catalog, and opens the database that the user selects. The first @DbColumn puts a list of the values in column 4 of the Databases by _Replica ID view in the temporary variable titles. The second @DbColumn puts a list of the values in column 2 of the Databases by _Replica ID view in the temporary variable servers. The third @DbColumn puts a list of the values in column 3 of the Databases by _Replica ID view in the temporary variable databases. The temporary variable list combines titles, servers, and databases for presentation to the user in @Prompt. The formula then parses the return value from @Prompt into a server name and database name for inclusion in the FileOpenDatabase @command.
titles := @DbColumn(""; "doc":"CATALOG.NSF"; "Databases by _Replica ID"; 4); servers := @DbColumn(""; "doc":"CATALOG.NSF"; "Databases by _Replica ID"; 2); databases := @DbColumn(""; "doc":"CATALOG.NSF"; "Databases by _Replica ID"; 3); list := titles + " *-* " + servers + " *:* " + databases; member := @Prompt([OKCANCELLIST]; "Open Database"; "Select a database"; ""; list); server := @Left(@Right(member; " *-* "); " *:* "); database := @Right(member; " *:* "); @Command([FileOpenDatabase]; server:database)