Change Supplier Code Missing Fields - SOLVED?

[TimSchofield]

Why don't we do something like:

PHP Code:

DB_IgnoreForeignKeys()
$Result = DB_query("UPDATE suppliers SET supplierid='" . $NewCode . "' WHERE supplierid='" . $OldCode . "'");

.....

DB_ReinstateForeignKeys() 


Gets rid of the need for developers to remember this script when adding a new field to the suppliers table.

Tim