Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing vfp databases from other apps
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00160756
Message ID:
00160822
Views:
16
Hi Ed, is me again.

As expectd, to use ODBC to access a vfp database is impossible to have a table indexed on a UDF. If there is the need to use a UDF it must contain at least one column in the declaration. All this to say that an index on deleted() will not work through ODBC.
It would be possible to index on a UDF that returns deleted() but it would be useless for optimizations in vfp. The question is (are?)

Does it make any sense to index on something useless?
What is the penalty, in terms of optimization, in not having a tag on deleted?

TIAS
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform