I've done a lot of manual editing within the Category table, to change the spelling of hundreds of categories. I haven't changed any other fields - just Name. This had to be done outside of Links SQL via some custom PHP programs.
I've now realised that the Full_Name field is out of date because it still contains references to the old data!
Is there a way of automatically rebuilding the Full_Name field to fix this? It will take me days to type everything by hand!
I must say, I'm a little disappointed that Links SQL sees a need to maintain a Full_Name field when the information can be derived from the rest of the database. Duplicating information like this is slightly against the rules of good database design.
I've now realised that the Full_Name field is out of date because it still contains references to the old data!
Is there a way of automatically rebuilding the Full_Name field to fix this? It will take me days to type everything by hand!
I must say, I'm a little disappointed that Links SQL sees a need to maintain a Full_Name field when the information can be derived from the rest of the database. Duplicating information like this is slightly against the rules of good database design.