General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows Server 2016
Virtual environment:
Hyper-V
>>>>>>is possible to create a calculated field in a VFP table?
>>>>>
>>>>>As Borislav said, not directly. You could probably do something rules.
>>>>>
>>>>>Tamar
>>>>
>>>>Calculated field is present in BROWSE,
>>>>I was hoping I had missed something.
>>>>
>>>>I will use DEFAULT for the INSERT and explicit UPDATE,
>>>>but the space in the DBF was the thing I wanted to avoid.
>>>
>>>BTW why you need it?
>>>You can have it in Browse, in Grid in every control you want.
>>
>>It is not a direct visible table, it is used on background with a data schema,
>>automatic calculated fields simplify the code..
>
>
>As Borislav said you don't need it. In SQL server too, except for the persisted ones, they are just definitions filled in during a select.
>
>You can index a cursor on the fly, and also as Hilmar pointed out you could index on an expression (what a calculated field is).
i cannot do it into sql server. i need minimal traffic on odbc sessions.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only