>>>I'm using a grid to populate a cursor in one of my form, I want to replace some of the cursor's fields with their default value everytime a new record is appended. How can this be done???
>>>
>>>TIA,
>>>
>>>Enmanuel
>>
>>Doesn't it work if you define a default value in the table definition?
>>
>>Hilmar.
>
>Yes it does, the problem is I'm not using a table, not even a free table, I'm using a cursor populated from the existing data where you can add or modify records. It's something like an invoice detail entry screen.
>
>Enmanuel
I think you should use a view (vista), instead of a regular cursor. Just create the view from the database container. The view, I believe, can be based on free tables.
The view is similar to a cursor, but Visual FoxPro can update the underlying tables (las tablas subyacentes) automatically. Normally you would use it with buffering (just as you would with any regular table), and save changes with TableUpdate() (or undo changes with TableRevert()).
HTH, Hilmar.
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)
