Let user pick a database

Document Subject: Let user pick a database
Hint Short Cut: Add this to your code & documentation to help you find this page.
http://#DatabasePicker or http://A555F9/nn.nsf/ByAlias/DatabasePicker

There is an easy way to allow a user to pick a database. This also shows how to use square bracket notation instead of nested @subset functions.

r:=@Prompt([ChooseDatabase];"";"");
FIELD Server:=r[1];
FIELD Filepath:=r[2];
FIELD Title:=r[3];
""

NB

@subset(r;1) = r[1]

@subset(@subset(r;2);-1) =r[2]

@subset(r;-1) = r[3]