Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Supplier Code Missing Fields - SOLVED?
12-13-2018, 09:47 PM
Post: #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
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)