Solved

Specifying the server and directory

Posted on 2000-04-28
2
149 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses

617 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