Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid page fault on requery
Message
From
20/01/1999 12:26:22
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
19/01/1999 16:43:39
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00177534
Message ID:
00178097
Views:
39
>Try to delete tags on view before requreing. The possible problem that if you have tags that VFP tries to rebuil them automatically during the requery process and having buffering=5 here may kill the system, i.e. another option is to change buffering setting before the requery.
>
>>We deleted and rebuilt the indexes and still have the same problem. Any other ideas? The view is only on 1 table.
>>
>>Thanks
>>
>>>Hi Sally,
>>>
>>>>I'm not sure what you mean about re-generating the index from scratch.
>>>
>>>When you requery the view it accesses the index of the table. If that index is corrupt, it would explain your problem. I meant, you shoul delete the index of the table (or all tables) that the view bases on and try again to requery the view.
>>>
>>>Christof

Seems to ring a bell. It said that views can be indexed if buffering is set to 3 or less; since requery() requires reindexing, it may be a good practice to set buffering off before requery, then set it back.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform