Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with local view indexing
Message
From
16/05/2005 09:41:13
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
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:
01014547
Views:
18
>Hi!
>
>I have a local view. And I want it index it. I put the following code in Form's DataEnvironment Init method:
>
Select <MyView>
>Index on <Field> Tag <TagName> 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?

As Hilmar said, should be something in the SQL of the view - depending on how you defined that field. Just make sure it's something that has a fixed length, and yields the same length when you USE ... NODATA.

Though, if its width may be changing, you should be getting error 1496 (or something like that) - view definition has changed.

My trick to catch such things was to open the view with NoData, List Structure. Then open it with data, list structure again, and compare. If everything's the same, you should be fine. If not - blame the fields which have different structure.

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