Page 1 of 1

Changing a Tables FIeld Name

Posted: Thu Feb 18, 2021 12:16 am
by icoso
Is there a documentation for how to change a field name in the Database table that would affect the forms and reports? I know how to actually change the fieldname in the table using PPHMyAdmin, Im talking about what consequences in the nuBuilder forms do I need to consider or change, for example: if I change a fields name from cust_BirthDate to cust_DOB in the database.

Re: Changing a Tables FIeld Name

Posted: Thu Feb 18, 2021 8:06 am
by kev1n
Change its Object ID and if it's used in the SQL, Browse Column, change it there too.
Then you could also dump the DB, search for the old column name in a text editor to make sure it isn't referenced anywhere else.