I have changed the contents of the field >> %KEY << in a table, named the new >> %KEY_unique <<.
I can then drop the field from only this table - because several other tables, all of which are going to be used to create a LinkTable, also contain a field >> %KEY << - but then, how can I rename that field >> %KEY_unique TO %KEY << just for this one table?
I guess that is the reason I am always getting a message "New field name already exists", even when, after dropping the existing field, there is no field >> %KEY << in this table - but there is in other tables ...
If a field get a new name it is just a small change within the meta-data but it couldn't work if this field already exists because a field contained only distinct values and they are connected through a pointer to the datatables - and both parts the symboltable behind the fieldvalues and also the pointer needs to be recreated/refreshed if there come new/further values - and this needs to be done with a load-statement and therefore the rename-statement reacts with an error-message.
I'm doing it another way and that seems to be working: I just don't create that field in that table before, so I don't have to change it and there is no need to DROP and RENAME.
