Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Calculated field
Message
De
20/01/2017 08:06:38
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
20/01/2017 06:59:53
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2016
Database:
MS SQL Server
Application:
Desktop
Virtual environment:
Hyper-V
Divers
Thread ID:
01646855
Message ID:
01646903
Vues:
56
J'aime (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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform