Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Records not visible or in double
Message
From
13/09/2018 17:45:22
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
13/09/2018 16:30:41
Al Doman (Online)
M3 Enterprises Inc.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01662003
Message ID:
01662022
Views:
35
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform