Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with local view indexing
Message
From
16/05/2005 08:29:08
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
16/05/2005 01:29:56
Eugene Kolmakov
Millennium Technologies
Vladivostok, Russia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01014483
Message ID:
01014520
Views:
22
>Hi!
>
>I have a local view. And I want it index it. I put the following code in Form's DataEnvironment Init method:
>

The variable information, < MyView >, etc., doesn't appear in the message (unless I edit it), because it is confused with HTML codes. It is better to include some spaces, as I did, or perhaps enclose it within < PRE > tags.

What exactly is the index expression? Perhaps it is a variable-length expression, which is known to cause trouble.

>Select
>Index on Tag ascending
>
>It worked until today. Now It doesn't work. Maybe I've changed some options in my application but I can't understand what exactly I could change.
>
>CDX file created after indexing has zero length and no indexes present.
>When I do the same from the command window it all works fine.
>
>Maybe anyone knows what is the problem?
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform