Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record not available
Message
From
10/05/2003 00:29:18
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00786085
Message ID:
00787007
Views:
23
>>>This problem is definately OS related. I tried running it from Win2k Server and NT4 Workstation, and it ran just fine using either of those as the server.
>>
>>Is there any AV running on the W98SE box?
>
>Guess what? Packing the table fixed the problem on the Win98SE box!

When all else fails, try the built-in VFP maintenance tools ;-)

Glad you got it fixed! Just today I was at a client who had a strange VFP5 issue, inserting new records into a transaction table. Adding a record with one particular value in one particular field crashed it every time, from multiple workstations. Other values in that field went in no problem. Tried reindexing the table, no effect. Ran a custom program that scans all rows and columns for "corrupt" data (low- or high-ASCII characters). It found one in a record dated February 25th. Cleaned up that field, reindexed, problem solved.
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform