Subject Trying to change a PK field name
Author edperkins_jr
Hi,

Can any one help a problem I am having?

I created a table with a field that has lower case characters. When I
try to use the field name in an UPDATE Firebird kicks back the field
name as Upper case and says it can not find the field in the table. I
have tried to change the field to upper case, but errors because the
field is the PK.

I have tryed to drop the field, alter the field, drop the index, drop
pthe constaint, and drop the table.

All data has been deleted from the table.

Any ideas?

Ed Perkins