General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only