PDA

View Full Version : Grouping the index files with the main file flag



Michel Boisvert
11-Mar-2005, 09:31 AM
Hi gang,

We split our application files in 2 directories, the system files all are
into the same directory and the specific company files are in another
directory. That way, implementing multiple companies if quite easy to set
up and to maintain.

The normal path is x:\companydata; x:\systemdata ...

When adding an index in a system file, it always gets created in one of the
company data and all other companies are left without the index creating
for sure emergency calls and possibly system crashes. (we use a remote
restructure procedure to update files automatically). It happened many times
during the last year and we are very prone to it.

We need a flag in the system to make all index files created in the same
directory the data file is in. (in fact it doesn't make sense to make it
otherwise - that is as it works now!)

Thanks

Michel Boisvert,

Bob Worsley
11-Mar-2005, 09:51 AM
Any _new_ indexes are always created in the first directory in the dfPath.
Bob

"Michel Boisvert" <ipso@qc.aira.com> wrote in message
news:bBa39bkJFHA.4924@dacmail.dataaccess.com...
> Hi gang,
>
> We split our application files in 2 directories, the system files all are
> into the same directory and the specific company files are in another
> directory. That way, implementing multiple companies if quite easy to set
> up and to maintain.
>
> The normal path is x:\companydata; x:\systemdata ...
>
> When adding an index in a system file, it always gets created in one of
the
> company data and all other companies are left without the index creating
> for sure emergency calls and possibly system crashes. (we use a remote
> restructure procedure to update files automatically). It happened many
times
> during the last year and we are very prone to it.
>
> We need a flag in the system to make all index files created in the same
> directory the data file is in. (in fact it doesn't make sense to make it
> otherwise - that is as it works now!)
>
> Thanks
>
> Michel Boisvert,
>
>

Garret Mott
11-Mar-2005, 10:00 AM
Michel -

In 2.3 days, I set up batch files to change the dfpath, reindex, change
dfpath, reindex, etc.:

@echo off
Set DFPath=C:\FirstFolder;C:\SecondFolder
DFIndex 1
Set DFPath=C:\SecondFolder;C:\FirstFolder
DFindex 2
etc.
Set DFPath="Back to what it was" //insert your path here

Don't know it this helps any... I wish DF used the .Dat location for the
..K* location.....

Garret

"Michel Boisvert" <ipso@qc.aira.com> wrote in message
news:bBa39bkJFHA.4924@dacmail.dataaccess.com...
> Hi gang,
>
> We split our application files in 2 directories, the system files all are
> into the same directory and the specific company files are in another
> directory. That way, implementing multiple companies if quite easy to set
> up and to maintain.
>
> The normal path is x:\companydata; x:\systemdata ...
>
> When adding an index in a system file, it always gets created in one of
> the company data and all other companies are left without the index
> creating for sure emergency calls and possibly system crashes. (we use a
> remote restructure procedure to update files automatically). It happened
> many times during the last year and we are very prone to it.
>
> We need a flag in the system to make all index files created in the same
> directory the data file is in. (in fact it doesn't make sense to make it
> otherwise - that is as it works now!)
>
> Thanks
>
> Michel Boisvert,
>

Michel Boisvert
11-Mar-2005, 10:18 AM
The problems has been with us for 15 years. What I need is a solution for
vdf, remote file restructuring, without problem.

Why in the first place would an index file be in a different directory than
it's data file ? It doesn't make sense to me ? But if it make sense for
somebody else, just set up a new flag for us who do always group index file
with the data file. No more problem.

Michel

"Garret Mott" <garret@automatesoftware.com> a écrit dans le message de news:
9wY3UskJFHA.1912@dacmail.dataaccess.com...
> Michel -
>
> In 2.3 days, I set up batch files to change the dfpath, reindex, change
> dfpath, reindex, etc.:
>
> @echo off
> Set DFPath=C:\FirstFolder;C:\SecondFolder
> DFIndex 1
> Set DFPath=C:\SecondFolder;C:\FirstFolder
> DFindex 2
> etc.
> Set DFPath="Back to what it was" //insert your path here
>
> Don't know it this helps any... I wish DF used the .Dat location for the
> .K* location.....
>
> Garret
>
> "Michel Boisvert" <ipso@qc.aira.com> wrote in message
> news:bBa39bkJFHA.4924@dacmail.dataaccess.com...
>> Hi gang,
>>
>> We split our application files in 2 directories, the system files all are
>> into the same directory and the specific company files are in another
>> directory. That way, implementing multiple companies if quite easy to
>> set up and to maintain.
>>
>> The normal path is x:\companydata; x:\systemdata ...
>>
>> When adding an index in a system file, it always gets created in one of
>> the company data and all other companies are left without the index
>> creating for sure emergency calls and possibly system crashes. (we use a
>> remote restructure procedure to update files automatically). It happened
>> many times during the last year and we are very prone to it.
>>
>> We need a flag in the system to make all index files created in the same
>> directory the data file is in. (in fact it doesn't make sense to make it
>> otherwise - that is as it works now!)
>>
>> Thanks
>>
>> Michel Boisvert,
>>
>
>

Knut Sparhell
11-Mar-2005, 11:19 AM
Michel Boisvert wrote:

> Why in the first place would an index file be in a different directory than
> it's data file ? It doesn't make sense to me ? But if it make sense for
> somebody else, just set up a new flag for us who do always group index file
> with the data file. No more problem.

It seems quite obvious to me. Only when creating a new table the
*first* datapath entry should be the default location.

--
Knut Sparhell, Norway