Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Avoiding extra fields in my table
Message
De
02/07/2002 21:41:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Avoiding extra fields in my table
Divers
Thread ID:
00674790
Message ID:
00674790
Vues:
59
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
Fil
Voir

Click here to load this message in the networking platform