Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rushmore, don't get it
Message
From
21/04/2005 09:19:56
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
21/04/2005 09:14:34
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01006860
Message ID:
01006951
Views:
20
>>Fabio,
>>It's a bug as agreed. Why would I ever reindex it. Assuming there might be a need, yes reindex kills the index but still you can give a kiss and bring it back to life in 2-3 lines of code.
>
>Cetin,
>How do you bring it back to life ?
>With a new table, index and Append the source table !?
>You can write these 2-3 lines ...
>
>But PACK, too, kill the index ! Can you live without PACK ?
>
>Next code close the door ( and open many ????? on the VFP data engine ):

Yes why not, VFP does it fast enough. ie:
Reindex
Select * from CursorTest into cursor temp
Select cursortest
Zap
Append From dbf('temp')
USE in 'temp'
In practice would you ever reindex a cursor. I never did:) Actually I wouldn't use bintoc() with cursors either.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform