Not sure if this is fixed in 6.3 but. If you rename a database field that is mentioned in an UPDATE() statement in a trigger, the field is not renamed correctly. Note this is the UPDATE([Fieldname]) syntax that returns true if a field has been updated, not the UPDATE SET [Fieldname] = xyz syntax for performing a database update.
For example, rename a field [Alpha] to [Alpha123]. In an Update trigger for the table containing this field is the statement:
IF UPDATE([Alpha])
do some SQL stuff;
This is checking to see if [Alpha] has been modified by the table update and of course it should be changed to IF UPDATE([Alpha123]) ... but it isn't and thus it causes the smart rename transaction to fail. Other references to [Alpha] within the trigger procedure are renamed correctly, looks like Prompt needs to check within an UPDATE() statement.
Hope this helps
For example, rename a field [Alpha] to [Alpha123]. In an Update trigger for the table containing this field is the statement:
IF UPDATE([Alpha])
do some SQL stuff;
This is checking to see if [Alpha] has been modified by the table update and of course it should be changed to IF UPDATE([Alpha123]) ... but it isn't and thus it causes the smart rename transaction to fail. Other references to [Alpha] within the trigger procedure are renamed correctly, looks like Prompt needs to check within an UPDATE() statement.
Hope this helps