Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Records not visible or in double
Message
De
13/09/2018 17:45:22
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
13/09/2018 16:30:41
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01662003
Message ID:
01662022
Vues:
36
>I have sometimes seen network switchgear go wonky if a site has power problems. You could try power-cycling the switch(es), especially if they haven't been power cycled for a long time.
>
>I've seen network delays/disconnects caused by bad patch cables but that only affects one workstation at a time. Server and closet patch cables are generally OK as long as they're good quality cables that meet spec e.g. Cat5e or better for gigabit networking. If they haven't been disconnected for years it might be worth disconnecting, then reconnecting them in case electrical contacts have become oxidized.

Even gold-plated can lose contact by having dust settling by vibration from the fans. Same cure applies.

>Exactly how are you rebuilding your indexes? Just running REINDEX is not good enough. One way to do it properly is to DELETE TAG ALL then re-add the tags. However as I understand it this can break referential integrity if you have RI defined in a VFP database. My preferred method is to overwrite the .CDX with a known good one (even if it's out of date, could be from your dev computer etc), then REINDEX (which will bring it back up-to-date).

My preferred method is to generate the code to save all the RI stuff etc, drop it, then drop each index by stuffing a zero in 29th (or was it 28th... depends how you count) byte, physically erasing cdx files, then building indexes in (generated) code, then reapplying the RI stuff. The code is a bit convoluted and generally not used in the last 15 years, but if anyone wants the generator, it still works.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform