Ended up removing one field from the structure that was being referenced in the RENAME command. And i blanked out the value in SDTMETA.PREVNAME field too. Watching it run, there was no RENAME command being issued. Just a DROP FIELD command. Appears to be working, but i'm not sure if the fieldname being dropped will be present for the various users who have dated versions of the dbc.

>For the particular table in question, the LCTODO varible appears to hold just about every field in the structure. The length of the value stored in LCTODO is 372 chars. And at the end of the value there is an

ALTER COLUMN TAKENDT NOT NULL

followed immediately with a command that tries to rename an existing field to that same TAKENDT field name.

RENAME COLUMN FIELDX TO TAKENDT

Little field name contention problem. Not sure how thats happening. This person may have missed a few updates.
>
>>Hi Chris.
>>
>>>I had renamed a field in a table structure and had changed the field type from DATE to DATETIME. The field is located in the middle of the table structure. When i go to update a particular client's database, i get the following error:
>>>
>>>

Error #12, Line 423 of UPDATEONETABLE
>>>Code Variable TAKENDT is not found

>>>
>>>That line of code looks like:
>>>
>>>

alter table (lcAlias) &lcToDo

>>>
>>>The table being updated DOES have the field TAKENDT in it
>>>
>>>The particular field in question has in its SDTMETA record the following:
>>>
>>>PREVNAME: RTAKEN
>>>REALNAME: TAKENDT
>>
>>What does lcToDo contain?
>>
>>Doug