RE: Index Question

Hi Catherine:

No, it should not make the program unstable. You might want to try this
code to recreate your indexes:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;202520

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003



>Thanks Lee Mitchell.
>Yes, the situation is I can see the CDX file but do not see the index tags
>when modify structure.
>I don't know when it will happen until some users report the system quit
>suddenly and then I open the table and found nothing on the index tags.
>I haven't used the REINDEX command and also haven't delete the index.
>Everytime I just recreate the index from scratch with the INDEX ON command
in
>command window.
>Will it make the system or tables not stable?




>"Lee Mitchell" wrote:

> Hi Catherine:
>
> I am not sure I understand. You see the CDX file but when you modify the
> structure of the table you do not see the index tags, right?
>
> If this is the case, does issuing a REINDEX command fix the problem?
Have
> you tried deleting and recreating the index from scratch with the INDEX
ON
> command or the MODI STRUCTURE command? (You want to delete the CDX file
> before recreating it.)
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
>
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/default.aspx?id=fh;[ln];lifeprodv
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
> >Dear all,
> > I am using VFP 6.0. I have created some indexes on the tables and
> don't
> >know why sometimes (more frequently now) the indexes lost automatically.
> But,
> >the ".cdx" files still exist. Sadly, it made the program ran with error
> and
> >quit automatically when trigger such tables.
> > I don't understand why the .cdx is exist but when I type the command
> >"modify structure" on the command window and found that the index
created
> >before was disappeared. How can I prevent such problem?
>
> > Thanks.




.

Relevant Pages

  • RE: Index Question
    ... Thanks Lee Mitchell. ... the situation is I can see the CDX file but do not see the index tags ... I haven't used the REINDEX command and also haven't delete the index. ...
    (microsoft.public.fox.helpwanted)
  • RE: Index Question
    ... You see the CDX file but when you modify the ... does issuing a REINDEX command fix the problem? ... you tried deleting and recreating the index from scratch with the INDEX ON ...
    (microsoft.public.fox.helpwanted)
  • Problems with msgboxes and focus
    ... This happens on a unitech PA960 running Windows CE 4.2, an IPAQ running Pocket PC and in the emulators ... If you want to recreate the problem do the following: ... a command button and a timer on a form ... Set the timer interval to 10000 and in its event set the focus to text box 2 ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: I havent got an icon for when I save my WORD 2003 document?
    ... > and remove the *.doc file extension? ... > If it happens on all documents then go to Start/Run and run the ... > following command to recreate the file associations for Word: ...
    (microsoft.public.word.docmanagement)
  • RE: Weird printing problem
    ... Mauro, you may have to recreate anything that affects the printer....start ... just remove and recreate the buttons or command line on their end. ... >> Destin Richter ...
    (microsoft.public.access.reports)