Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CDX replacement
Message
From
30/04/2007 09:23:28
 
 
To
29/04/2007 15:41:18
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01220801
Message ID:
01221071
Views:
21
>I should have been clearer - what I meant by "radical" as a UDF expression is the case where the UDF references something that, for example, exists only within the app e.g. goApp.SomeProperty or goApp.SomeMethod().

Okay, that is more complicated, but not impossible.

Nevertheless I like that and how easy that approach works compared to what Naomi suggests: While it might be cleaner to delete all tags and create indexes from meta data or a saved script like gendbc creates, it's really simple to use an empty cdx file saved at table creation and then use REINDEX to rebuild the CDX file. Even if you did not save an empty cdx you could use any working version or could use gendbc, recreate the empty database and use that cdx file as a base for REINDEX, very universal.

And regarding those impossible to recreate indexexpressions like Datetime() or Rand(), you have the same problem to reindex that using Naomis technique.

Bye, Olaf.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform