Lookup across drives

[Walter D Vaughan Jr]

Top posted from outlook. Anyways...

 *IF* you are looking to just *read* the information on your M: drive you
can setup on your filePro installation on your G: drive, alien files that
are attached to the native filePro files on your M: drive. You would have to
determine what the record number would be on the G drive then do a record
lookup plus one at the alien file (Record#1 in G would be record #2 in the
alien file). If you change anything in a indexed field or add in new fields
you will have to trigger on your M drive a re-indexing routine.

What will get you much better information is what you are trying to solve?
As in "I have hundreds of filePro tables for internal use", and I only want
a few of them duplicated for use in a web application. However I am
concerned that my duplicates are not staying in sync, how can prove that is
not happening?" Is that what you are asking?

And thinking even more strategic is what you are doing is called an ETL
operation. Instead of re-inventing the wheel, you might look at best
practices http://en.wikipedia.org/wiki/Extract,_transform,_load

-----Original Message-----
From: filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com
[mailto:filepro-list-bounces+wvaughan=steelerubber.com at lists.celestial.com]
On Behalf Of Richard Tartaglia
Sent: Saturday, November 03, 2012 12:38 PM
To: filePro Mailing List
Subject: Lookup across drives

It has been a while since I've posted but I read and learn as much as
possible from all of you and your experience. I thank you all for that
opportunity. 
 
I am running a windows 2003 server that is broken into 3 drives. The root is
just used for normal operation. I have a drive dedicated to running filepro
on the on the web. The third drive is for inter office running of filepro.
The office filepro writes a file to the web drive so it can generate data
used by a run time copy of filepro. 
 
I would like to do a look up from the mapped office drive g: to the mapped
web drive m:. Is this possible?
 
I am running filepro 5.0 on the windows 2003 server and have 1 windows xp
box linked to that. 
 
The reason for the web drive and the office drive is because the
information located on the office drive is sensitive.
 
Any suggestions would be appreciated 
 
Thanks 
 
Rich
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://mailman.celestial.com/pipermail/filepro-list/attachments/20121103/490
b4e0b/attachment.html
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list