Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speedy Parameterized Views
Message
From
22/04/2000 00:17:33
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00362443
Message ID:
00362461
Views:
14
Nick,

>In your case you may create IDX indexes which will not touch your table format in any way:
>
>INDEX ON custid TO cistid.idx COMPACT

But then he will have to rebuild the index every time he uses the view in case the DOS app has changed something or added records -- or he will have to change the DOS app to maintain that .idx.

That's why I recommended the index tag approach to create a structural .CDX that will be auto-maintained without changes to the DOS app (unless of course it is an old-enough version that it doesn't support CDX's).
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform