Solved

Specifying the server and directory

Posted on 2000-04-28
2
146 Views
Last Modified: 2013-12-18
Please help I need to specify the current server and directory of the database on the server on local machine for remote users.  At present I do a DB_Look in a view with the path and database name but this is a pain to maintain with 15 databases.

The server is "Development"
The path is "\ABCWorks\Development\Version1"
The database is "Supplier.nsf"

The code I use at present is as follows

ServerName:= @Name([CN]; @Subset(@DbName;1) );
DB_PATH := @DbLookup(""; ""; "LookUp"; "DB_Path";2);
DB_Lookup := @DbLookup(""; ""; "LookUp"; "DB_Name00";2);
DB_Loc :=DB_PATH+DB_Lookup;

list:= @DbColumn("";ServerName:DB_Loc;"F11LookUp";1);
supplier := @Prompt([OKCANCELLIST];"Select Supplier"; "Select a Supplier from the list";"";@Unique(list));

I have a piece of code but for some reason it doesn't work

SubDir := @LeftBack(@Subset(@DbName;1) ;"\\");
DB_Name := @if(SubDir = "";"";SubDir + "\\") + "Supplier.nsf";

Please help
0
Comment
Question by:fayeb
2 Comments
 
LVL 3

Accepted Solution

by:
Gunsen earned 50 total points
ID: 2760097
Use -1 in the subset function :
SubDir := @LeftBack(@Subset(@DbName;-1) ;"\\");
The DBName returns Server; Path, and we want the last one.
0
 

Author Comment

by:fayeb
ID: 2820437
Thank you very much for your help
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question