jvanhalderen
asked on
Select server / directory
Hi all,
I created an agent that creates a new database. Now I'd like the user to select the destination of the database him/herself. So I need something that lists down all servers and directory on it but NOT the files.
Basicly I need the same pop-up as notes has when you select create new database. Formula or script I dont care.
@Prompt([ChooseDatabase]; "";"3") Wont work. because it shows the files as well.
I created an agent that creates a new database. Now I'd like the user to select the destination of the database him/herself. So I need something that lists down all servers and directory on it but NOT the files.
Basicly I need the same pop-up as notes has when you select create new database. Formula or script I dont care.
@Prompt([ChooseDatabase]; "";"3") Wont work. because it shows the files as well.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Well, Cant you use the Directory's view of the servers and show in the promptlist ???
I am just curious....
To get the current server use the @Subset(@DbName ; 1)
You know the db name "names.nsf"
You will know the servers view is "Servers"
The column is 3
Why dont you do a @dbcolumn with all the parameters to get a list of all servers names and show it using an @Prompt list function ???
I am just curious.....
:-)
Arun.
I am just curious....
To get the current server use the @Subset(@DbName ; 1)
You know the db name "names.nsf"
You will know the servers view is "Servers"
The column is 3
Why dont you do a @dbcolumn with all the parameters to get a list of all servers names and show it using an @Prompt list function ???
I am just curious.....
:-)
Arun.
Ok, and then... ???
uh Oh !
I thought he needs only the servers. Now i got the whole point.
Hee Hee Hee !
Hold on guys i think we have an application running here. Let me c&p the code here !
;-)
Arun.
I thought he needs only the servers. Now i got the whole point.
Hee Hee Hee !
Hold on guys i think we have an application running here. Let me c&p the code here !
;-)
Arun.
Hello jvanhalderen,
from the history of your answered questions I see that you often give a B or even worse a C grading! This is not good.
The grading is not school grading; it is expert points multiplication factor.
So please give an A+ for my efforts. Thanks :-)
from the history of your answered questions I see that you often give a B or even worse a C grading! This is not good.
The grading is not school grading; it is expert points multiplication factor.
So please give an A+ for my efforts. Thanks :-)
You Beggar !
You Cheat !
You Bro !
I Like your approach anyways.... hee hee hee!
;-)
Arun
PS: Our app is completely different, this prompts to key in the directory...hmmmm....you win !
You Cheat !
You Bro !
I Like your approach anyways.... hee hee hee!
;-)
Arun
PS: Our app is completely different, this prompts to key in the directory...hmmmm....you win !
Good night Bro <|:-)
Hello jvanhalderen,
if you have any questions about my code then ask them now.
I go sailing on Friday :-)
And please do not be so thrifty with your comments :)
If you do not like to write it in English then feel free to write to me in German, Bavarian, Serbo-Croatian, Macedonian or in Dutch to: paunoski@freenet.de
if you have any questions about my code then ask them now.
I go sailing on Friday :-)
And please do not be so thrifty with your comments :)
If you do not like to write it in English then feel free to write to me in German, Bavarian, Serbo-Croatian, Macedonian or in Dutch to: paunoski@freenet.de
Oh boy you are for a biggie...2k for sure huh ? Enjoy buddy !
:-)
Arun.
:-)
Arun.
I hope so :)
This vacations will move a lot of points from me to you :)
This vacations will move a lot of points from me to you :)
ASKER
A++
RESPECT!! thnx a lot
RESPECT!! thnx a lot
That was an awesome grade for my Bro...
Thanks Jvanhalderen ! Few more like this to my buddy he will be on top of me ! Right Zvo ?
:-)
Arun.
Thanks Jvanhalderen ! Few more like this to my buddy he will be on top of me ! Right Zvo ?
:-)
Arun.
Yeapy!!!
Thanks jvanhalderen, for the points and for the feedback :-)
Thanks jvanhalderen, for the points and for the feedback :-)
Any of the users has to be allowed to create databases on these servers. Are you aware of this? Most installation forbids such actions without Administrators.
On web it is no problem...