Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index Error 1884
Message
From
05/04/2016 09:24:43
Lutz Scheffler (Online)
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
05/04/2016 09:23:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 8.1
Network:
SAMBA Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01634277
Message ID:
01634315
Views:
26
>>>>Deleted record was the solution.
>>>>Late coworker had added a place to delete records I've never thought off.
>>>>
>>>>Customer seems to use this on regular base, but normaly the garbage collection catches the problem.
>>>>
>>>>(>ლ)
>>>
>>>An index on !deleted() may help
>>>
>>>index ..... for !deleted() 
>>>
>>
>>Changing tableupdate(0, to tableupdate(.T., solved it an instance without touching the index. It was very simple. :) I will keep the FOR clause of INDEX in mind, anyway.
>
>INDEX... for disables Rushmore optimization

Thank you.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform