Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculated field
Message
From
20/01/2017 08:06:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
20/01/2017 06:59:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Virtual environment:
Hyper-V
Miscellaneous
Thread ID:
01646855
Message ID:
01646903
Views:
55
Likes (1)
>>>is possible to create a calculated field in a VFP table?
>>You need to create a view on the table and use that view
>
>Thank you.
>I need an index on computed field :(

You may already this, but just in case: you can create an index on any expression, not just on a single field. Thus, you can create an index on a combination of two fields (usually you would convert them to character), or even on parts of fields, and then you can quickly search for the corresponding value - also concatenated - in the index.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform