Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Avoiding extra fields in my table
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement