• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 152
  • Last Modified:

Specifying the server and directory

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
fayeb
Asked:
fayeb
1 Solution
 
GunsenCommented:
Use -1 in the subset function :
SubDir := @LeftBack(@Subset(@DbName;-1) ;"\\");
The DBName returns Server; Path, and we want the last one.
0
 
fayebAuthor Commented:
Thank you very much for your help
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now