Reserved words
Something that's been irritating me of late...
ISQL will let me do this:
create table foo (
absolute char(1),
accept char(1),
after char(1),
array char(1),
ascending char(1),
ascii char(1),
at char(1),
attribute char(1),
attributes char(1),
average char(1)
);But I think that you would agree that it is rather of a bad idea :-)
(This example is contrived, but it reflects a technique that I often use
for shooting myself in the foot).
It would be rather nice if the back end refused to create tables or fields
with names that are reserved words in *any* Informix product (or at least
warned you that it was probably a bad idea).
Any hope?
Andrew
--
Work: gaffer@rec.com Phone: +44 793 614 110 Fax: +44 793 614 297
Play: andrew@tug.com Phone: +44 256 464 912