Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Avoiding extra fields in my table
Message
From
02/07/2002 21:41:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Avoiding extra fields in my table
Miscellaneous
Thread ID:
00674790
Message ID:
00674790
Views:
58
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.
Next
Reply
Map
View

Click here to load this message in the networking platform