SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot INSERT SODT because SOHD does not exist.
I am trying to insert data into table SOHD but am getting an error as above. I'm insert to table SOHD it success.
$sodt = $conn->prepare("INSERT INTO SODT (SOID, GoodID, GoodQty2, GoodPrice2, GoodAmnt, ShipDate, ListNo, DocuType, GoodType)
VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)");
$params1 = array($_POST['SOID'], $_POST['GoodID'], $_POST['GoodQty2'], $_POST['GoodPrice2'], $_POST['GoodQty2']*$_POST['GoodPrice2'], $_POST['ShipDate'], $_POST['ListNo'], $_POST['Docu开发者_JAVA技巧Type'], $_POST['GoodType']);
$sodt->execute($params1);
pic
sodt1sodt2sodt3 sohd1sohd2sohd3sohd4
精彩评论