Search code examples
lotus-dominolotus

Get list of all databases from server

I'm trying to create functionality mentioned in the title. The idea that I have in mind is that I have a form, where I can select the server/-s (i have achieved that with a simple dialog list). So far I have this in my dialog list:

servers:=@Name([Abbreviate];@DbColumn("";   @If(@Subset(@DbName;1)="";"";@Subset(@DbName;1)) :"names.nsf";"($Servers)";1));
@Unique(@If(@IsError(servers);"";servers))

What I'm having problem is with selecting the databases available in the selected server/-s. Can anyone give me a hint on how to do this? Haven't really tried anything because I couldn't find the information.

Solution

  • Depending on your needs, it does not have to be that complicated: @Prompt has a special mode for picking a database:

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