>>>>>>>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.
I didn't say "do it in SQL server". What I meant was, in SQL server too, calculated fields are only a definition and filled on select.