>Hi
>
>In a table I got some fields that basically help me to select
>records in a grid and many things more. The interface works just
>fine, the only problem is that for certain percentage of the re-
>cords in the table these fields are totally useless as the interface
>I use for these records never use these fields, so I think that using
>them is a waste. So I tried to solve this with a view like this:
>
>create sql view 'Myview' as select " " as 'selected',;
> table.id from dbc!table
>
>When I use the browser to see this view you can change the value
>of the field 'selected', but when I use this view in a grid I can't
>(the value of the field is an f and I can't change it). So I wonder how
>I can get this view to work with the grid or find another way to elimi-
>nate these fields from the table or maybe just make do with that nobody is
>perfect and let it by.
>
>Thanks in advance
>
>
>P.D the field 'selected' can be a character or logic. This field help
>me a lot for deleting or changing multiple records in my table and is
>very used in a scan statements.

Just keep this new field in a view and don't worry. Usually Selected is a logical field and represented as a checkbox in a grid.