I have an error in purchase order qty update section of my database. I need help looking at my code to find the error please!
<?php
// For help on using hooks, please refer to https://bigprof.com/appgini/help/workin ... tion/hooks
function Purchase_Order_init(&$options, $memberInfo, &$args){
return TRUE;
}
function Purchase_Order_header($contentType, $memberInfo, &$args){
$header='';
switch($contentType){
case 'tableview':
$header='';
break;
case 'detailview':
$header='';
break;
case 'tableview+detailview':
$header='';
break;
case 'print-tableview':
$header='';
break;
case 'print-detailview':
$header='';
break;
case 'filters':
$header='';
break;
}
return $header;
}
function Purchase_Order_footer($contentType, $memberInfo, &$args){
$footer='';
switch($contentType){
case 'tableview':
$footer='';
break;
case 'detailview':
$footer='';
break;
case 'tableview+detailview':
$footer='';
break;
case 'print-tableview':
$footer='';
break;
case 'print-detailview':
$footer='';
break;
case 'filters':
$footer='';
break;
}
return $footer;
}
function Purchase_Order_before_insert(&$data, $memberInfo, &$args){
return TRUE;
}
function Purchase_Order_after_insert($data, $memberInfo, &$args){
sqlvalue("UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + {$data['Qty_Received']} where i.InventoryID={$data['Part_Number']}");
return TRUE;
}
function Purchase_Order_before_update(&$data, $memberInfo, &$args){
$new_value=sqlvalue("SELECT ({$data['Qty_Received']} - Qty_Received) as qty from Purchase_Order where Purchase_OrderID = {$data['selectedID']} ");
if ($new_value <> 0) {
sqlvalue("UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + {$new_value} where i.InventoryID={$data['Part_Number']}"); }
return TRUE;
}
function Purchase_Order_after_update($data, $memberInfo, &$args){
return TRUE;
}
function Purchase_Order_before_delete($selectedID, &$skipChecks, $memberInfo, &$args){
return TRUE;
}
function Purchase_Order_after_delete($selectedID, $memberInfo, &$args){
}
function Purchase_Order_dv($selectedID, $memberInfo, &$html, &$args){
}
function Purchase_Order_csv($query, $memberInfo, &$args){
return $query;
}
function Purchase_Order_batch_actions(&$args){
return array();
}
Purchase_Order_view.php
Re: Purchase_Order_view.php
UPDATE Inventory i set i.Stock_QTY = i.Stock_QTY + where i.InventoryID=191
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where i.InventoryID=191' at line 1
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'where i.InventoryID=191' at line 1