Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Intermittent problem indexing a view
Message
From
10/12/2008 01:11:31
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01366193
Message ID:
01366390
Views:
11
>Turns out I was distributing the VFP9 SP1 runtimes w/ an EXE created w/ SP2. Not recommended. Which explains why i couldnt replicate the problem on a SP2 box here.
>
>I found this comment (which described the problem exactly)...
>
>
VFP9: Unexpected “File is not open” error reported by INDEX ON command after DELETE TAG ALL for a structural CDX on a View.
>
>at http://www.unpack.cn/viewthread.php?tid=18284
>
>I swapped out the runtimes for the SP2 versions and the problem went away.

Thanks for following up!

If lurkers would rather not go to Chinese domains due to high levels of malware infestation, here's the official MS VFP9 SP2 bug fix list:
http://download.microsoft.com/download/e/f/f/efff372d-5f27-414c-ae18-177170bf676d/VFP9SP2_BugFixList.htm
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
Next
Reply
Map
View

Click here to load this message in the networking platform