Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Change Branch Code Missing Fields - SOLVED?
12-13-2018, 02:29 AM (This post was last modified: 12-13-2018 02:36 AM by VortecCPI.)
Post: #1
Change Branch Code Missing Fields - SOLVED?
Z_ChangeBranchCode.php

Missing the following fields:

`defaultshipvia`,
`deliverblind`,
`specialinstructions`,


I believe this should do it:

PHP Code:
$sql "INSERT INTO custbranch (`branchcode`,
                    `debtorno`,
                    `brname`,
                    `braddress1`,
                    `braddress2`,
                    `braddress3`,
                    `braddress4`,
                    `braddress5`,
                    `braddress6`,
                    `estdeliverydays`,
                    `area`,
                    `salesman`,
                    `fwddate`,
                    `phoneno`,
                    `faxno`,
                    `contactname`,
                    `email`,
                    `defaultlocation`,
                    `taxgroupid`,
                    `defaultshipvia`,
                    `deliverblind`,
                    `disabletrans`,
                    `brpostaddr1`,
                    `brpostaddr2`,
                    `brpostaddr3`,
                    `brpostaddr4`,
                    `brpostaddr5`,
                    `brpostaddr6`,
                    `defaultshipvia`,
                    `specialinstructions`,
                    `custbranchcode`)
            SELECT '" 
$_POST['NewBranchCode'] . "',
                    `debtorno`,
                    `brname`,
                    `braddress1`,
                    `braddress2`,
                    `braddress3`,
                    `braddress4`,
                    `braddress5`,
                    `braddress6`,
                    `estdeliverydays`,
                    `area`,
                    `salesman`,
                    `fwddate`,
                    `phoneno`,
                    `faxno`,
                    `contactname`,
                    `email`,
                    `defaultlocation`,
                    `taxgroupid`,
                    `defaultshipvia`,
                    `deliverblind`,
                    `disabletrans`,
                    `brpostaddr1`,
                    `brpostaddr2`,
                    `brpostaddr3`,
                    `brpostaddr4`,
                    `brpostaddr5`,
                    `brpostaddr6`,
                    `defaultshipvia`,
                    `specialinstructions`,
                    `custbranchcode`
            FROM custbranch
            WHERE debtorno='" 
$_POST['DebtorNo'] . "'
            AND branchcode='" 
$_POST['OldBranchCode'] . "'"

https://www.linkedin.com/in/eclipsepaulbecker
Visit this user's website Find all posts by this user
Quote this message in a reply
12-13-2018, 09:53 PM
Post: #2
RE: Change Branch Code Missing Fields - SOLVED?
See my comment on the change supplier thread
Visit this user's website Find all posts by this user
Quote this message in a reply
Post Reply 


Forum Jump:


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