Automatic reindexing...A newbie asks

Greetings All:

I am new to VFP and would like to know how I can set up regular
reindexing of a database so it doesn't have to be done manually - I
sometimes forget to do it on a regular basis. Thanks in advance.

--

_______________
Regards,

Jerry M. Gartner

Dan_Musicant
Sat Sep 18 19:59:26 CDT 2004

On Sat, 18 Sep 2004 19:39:58 -0500, "Jerry M. Gartner"
<user@example.com> wrote:

:Greetings All:
:
: I am new to VFP and would like to know how I can set up regular
:reindexing of a database so it doesn't have to be done manually - I
:sometimes forget to do it on a regular basis. Thanks in advance.

I haven't done it but you could set it up various ways. One would be to
use the Windows Scheduler to run a program that does the task. You could
reindex, but preferably you delete the tags and index from "scratch"
using the TAG definitions. It's no biggie if you don't, but it is
cleaner and somewhat more reliable (I'm told).

Or, if you don't want it done like clockwork, you could have it as part
of a function that runs at specific times in your application, say when
it's opened, or when it's opened for the first time on any specific day.
I have a function that runs just the first time on any specific day,
myself, for an app that I use virtually daily. You could check the file
date on the CDX to determine that using the FDATE() function.

Dan

Stefan
Sat Sep 18 22:52:09 CDT 2004

Hi,
See also Doug Hennig's SDT tool at www.stonefield.com


hth
-Stefan

"Jerry M. Gartner" <user@example.com> schrieb im Newsbeitrag
news:OynniCenEHA.3464@tk2msftngp13.phx.gbl...
> Greetings All:
>
> I am new to VFP and would like to know how I can set up regular
> reindexing of a database so it doesn't have to be done manually - I
> sometimes forget to do it on a regular basis. Thanks in advance.
>
> --
>
> _______________
> Regards,
>
> Jerry M. Gartner
>
>

Demetrios
Sat Sep 18 23:32:09 CDT 2004

Jerry,

Why you would like to reindex on a regural basis?
Indexes are updated automaitically and only if corrupted should be
recreated.

Demetrios, Greece

"Jerry M. Gartner" <user@example.com> wrote in message
news:OynniCenEHA.3464@tk2msftngp13.phx.gbl...
> Greetings All:
>
> I am new to VFP and would like to know how I can set up regular
> reindexing of a database so it doesn't have to be done manually - I
> sometimes forget to do it on a regular basis. Thanks in advance.
>
> --
>
> _______________
> Regards,
>
> Jerry M. Gartner
>
>

Rick
Mon Sep 20 12:19:03 CDT 2004

Gary,
It will once the table is closed by all openers. The OS only updates =
this file date when a file is physically closed (i.e. no longer in use =
by anyone).

Rick


"GaryZ" <GaryZ@discussions.microsoft.com> wrote in message =
news:E16279FF-B50C-4FAD-B81E-364DBB174EE6@microsoft.com...
> Something I've noticed:
>=20
> If you USE a table SHARED, change a field value in the table, this =
does not=20
> change the Modified DateTime of the table. I went back into the table =
and=20
> checked. The field does contain the changed value, but the Modified =
DateTime=20
> remains as before.
>=20
> While this does not come into play in this case, it's important to =
note.=20
>=20
> "Dan_Musicant" wrote:
>=20
>> On Sat, 18 Sep 2004 19:39:58 -0500, "Jerry M. Gartner"
>> <user@example.com> wrote:
>>=20
>> :Greetings All:
>> :
>> : I am new to VFP and would like to know how I can set up regular
>> :reindexing of a database so it doesn't have to be done manually - I
>> :sometimes forget to do it on a regular basis. Thanks in advance.
>>=20
>> I haven't done it but you could set it up various ways. One would be =
to
>> use the Windows Scheduler to run a program that does the task. You =
could
>> reindex, but preferably you delete the tags and index from "scratch"
>> using the TAG definitions. It's no biggie if you don't, but it is
>> cleaner and somewhat more reliable (I'm told).
>>=20
>> Or, if you don't want it done like clockwork, you could have it as =
part
>> of a function that runs at specific times in your application, say =
when
>> it's opened, or when it's opened for the first time on any specific =
day.
>> I have a function that runs just the first time on any specific day,
>> myself, for an app that I use virtually daily. You could check the =
file
>> date on the CDX to determine that using the FDATE() function.
>>=20
>> Dan
>>=20
>>

GaryZ
Mon Sep 20 08:43:08 CDT 2004

Something I've noticed:

If you USE a table SHARED, change a field value in the table, this does not
change the Modified DateTime of the table. I went back into the table and
checked. The field does contain the changed value, but the Modified DateTime
remains as before.

While this does not come into play in this case, it's important to note.

"Dan_Musicant" wrote:

> On Sat, 18 Sep 2004 19:39:58 -0500, "Jerry M. Gartner"
> <user@example.com> wrote:
>
> :Greetings All:
> :
> : I am new to VFP and would like to know how I can set up regular
> :reindexing of a database so it doesn't have to be done manually - I
> :sometimes forget to do it on a regular basis. Thanks in advance.
>
> I haven't done it but you could set it up various ways. One would be to
> use the Windows Scheduler to run a program that does the task. You could
> reindex, but preferably you delete the tags and index from "scratch"
> using the TAG definitions. It's no biggie if you don't, but it is
> cleaner and somewhat more reliable (I'm told).
>
> Or, if you don't want it done like clockwork, you could have it as part
> of a function that runs at specific times in your application, say when
> it's opened, or when it's opened for the first time on any specific day.
> I have a function that runs just the first time on any specific day,
> myself, for an app that I use virtually daily. You could check the file
> date on the CDX to determine that using the FDATE() function.
>
> Dan
>
>