Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Supplier Code Missing Fields - SOLVED?
12-13-2018, 09:47 PM,
#2
RE: Change Supplier Code Missing Fields - SOLVED?
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
Reply


Messages In This Thread
RE: Change Supplier Code Missing Fields - SOLVED? - by falkoner - 12-13-2018, 09:47 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)