@prompt and database properties

Hi,

I have a application that has the property ‘show in database open dialog’ set to off.

I then use formula language i a button to select application

'result := @Prompt([ChooseDatabase];“”;“”);

FIELD LinkedDbPath := result[2];

FIELD LinkedDbTitle := result[3];’

resulting in my field LinkedDbTitle being empty.

If I set the applications property ‘show in database open dialog’ to checked it works fine.

But since I don’t want user to see the application when opening I wonder if there is another way to get the title to my field.

Regards Palle

Subject: Thoughts re @prompt vs hiding dbs from the dialog

If you want to allow users to choose a database that has “show in database open dialog” disabled, I think you’ll have to use some way other than @prompt([ChooseDatabase]).

Hopefully you have a few, predictable databases to choose from and you can create a configuration document per destination database, then do a @Picklist to that view.

Or maybe you can do both… have a “choose from common dbs” that uses a @Picklist of a short list of dbs, and also have a “Browse” button that uses @Prompt([ChooseDatabase]).

You might need to use LotusScript and use a NotesDbDirectory object to iterate through them, but you’ll have difficulty making a nice interface for the users from that.

This might seem rude, but one big question is “Why do you want to be able to see the db in a dialog but not be able to see it in a dialog?” If you’re relying on people not seeing the database “security through obscurity” then there are larger problems you should consider.