RE: Z_ChangeStockCode.php deactivates Serialised
The query should read:
$sql = "INSERT INTO stockmaster (stockid,
categoryid,
description,
longdescription,
units,
mbflag,
actualcost,
lastcost,
materialcost,
labourcost,
overheadcost,
lowestlevel,
discontinued,
serialised,
controlled,
eoq,
volume,
grossweight,
barcode,
discountcategory,
taxcatid,
decimalplaces,
shrinkfactor,
pansize,
netweight,
perishable,
nextserialno)
SELECT '" . $_POST['NewStockID'] . "',
categoryid,
description,
longdescription,
units,
mbflag,
actualcost,
lastcost,
materialcost,
labourcost,
overheadcost,
lowestlevel,
discontinued,
serialised,
controlled,
eoq,
volume,
grossweight,
barcode,
discountcategory,
taxcatid,
decimalplaces,
shrinkfactor,
pansize,
netweight,
perishable,
nextserialno
FROM stockmaster
WHERE stockid='" . $_POST['OldStockID'] . "'";
Tim
|