我在update语句中遇到错误语法错误，代码有什么问题？ [英] I got error syntax error in update statement, what is the wrong with the code ?

问题描述

'更新adjustHead&AdjustmentDetails

'--------------------------------- ----------



'更新AdjustmentHead

strSql =UPDATE AdjustmentHead SET AdjustmentHead。[Adjustment + V] =&Forms！[AdjustmentHead]！[Adjustment + V]&，AdjustmentHead。[Adjustment-V] =&[Forms]！[AdjustmentHead]！[Adjustment-V2]&，AdjustmentHead.AdjustmentStatus = -1， AdjustmentHead.AdjTransactionID =&intTransactionID&，AdjustmentHead.AdjOrderID ='&strOrderID&'

strSql = strSql&WHERE（（（AdjustmentHead.AdjustmentHeadID）= [Forms]！[AdjustmentHead ]！[AdjustmentHeadID]））;

DoCmd.RunSQL strSql



'更新调整

strSql = UPDATE AdjustmentDetailsQ INNER JOIN Items ON AdjustmentDetailsQ.ItemID = Items.ItemID SET Items。[In] = [Items]！[In] + [AdjustmentDetailsQ]！[OrderQty]，Items.Out = [Items]！[Out] + [ AdjustmentDetailsQ]！[IssueForLocal] + [AdjustmentDetailsQ]！[ IssueForForign]，Items.CIN = [Items]！[CIN] + [AdjustmentDetailsQ]！[OrderCQty]，Items.COut = [Items]！[COut] + [AdjustmentDetailsQ]！[IssueForLocal]

strSql = strSql&WHERE（（AdjustmentDetailsQ.AdjustmentHeadID）= [Forms]！[AdjustmentHead]！[AdjustmentHeadID]）AND（（AdjustmentDetailsQ.ActQOnH）不为空））;

DoCmd .RunSQL strSql



strSql =UPDATE订单SET Orders.Adj = -1

strSql = strSql&WHERE（（订单） .OrderID）喜欢'adj *'））;

DoCmd.RunSQL strSql





strSql = UPDATE Transactions SET Transactions.AdjTrans = -1

strSql = strSql&WHERE（（Transactions（Trans.TransactionNo）Like'* Adj *'））;

DoCmd.RunSQL strSql





'结账表格



DoCmd.Close

'Updating AdjustmentHead & AdjustmentDetails
'-------------------------------------------

'update AdjustmentHead
strSql = "UPDATE AdjustmentHead SET AdjustmentHead.[Adjustment+V] = " & Forms![AdjustmentHead]![Adjustment+V] & ", AdjustmentHead.[Adjustment-V] = " & [Forms]![AdjustmentHead]![Adjustment-V2] & ", AdjustmentHead.AdjustmentStatus = -1, AdjustmentHead.AdjTransactionID = " & intTransactionID & ", AdjustmentHead.AdjOrderID = '" & strOrderID & "'"
strSql = strSql & " WHERE (((AdjustmentHead.AdjustmentHeadID)=[Forms]![AdjustmentHead]![AdjustmentHeadID]));"
DoCmd.RunSQL strSql

'update Adjustment
strSql = "UPDATE AdjustmentDetailsQ INNER JOIN Items ON AdjustmentDetailsQ.ItemID = Items.ItemID SET Items.[In] = [Items]![In]+[AdjustmentDetailsQ]![OrderQty], Items.Out = [Items]![Out]+[AdjustmentDetailsQ]![IssueForLocal]+[AdjustmentDetailsQ]![IssueForForign], Items.CIN = [Items]![CIN]+[AdjustmentDetailsQ]![OrderCQty], Items.COut = [Items]![COut]+[AdjustmentDetailsQ]![IssueForLocal]"
strSql = strSql & " WHERE (((AdjustmentDetailsQ.AdjustmentHeadID)=[Forms]![AdjustmentHead]![AdjustmentHeadID]) AND ((AdjustmentDetailsQ.ActQOnH) Is Not Null));"
DoCmd.RunSQL strSql

strSql = "UPDATE Orders SET Orders.Adj = -1"
strSql = strSql & " WHERE (((Orders.OrderID) Like 'adj*'));"
DoCmd.RunSQL strSql


strSql = "UPDATE Transactions SET Transactions.AdjTrans = -1"
strSql = strSql & " WHERE (((Transactions.TransactionNo) Like '*Adj*'));"
DoCmd.RunSQL strSql


'Closing Form

DoCmd.Close

推荐答案

看起来你可能需要围绕你的一些价值观引用，如何呃，不要试图修复你的代码。请更改您必须使用参数的代码，以便正确执行。



例如：

It looks like you might need quotes around some of your values, however, do not try to fix the code you have. Please change the code you have to use parameters so that you are doing it correctly.

For example:

String sql = "UPDATE table1 SET field1=@field1, field2=@field2...
...
cmd.Parameters.AddWithValue("@field1", txtField1.Text);
cmd.Parameters.AddWithValue("@field2", txtField2.Text);
...

完成后这样你的语法问题就会消失。

Once you have done it this way your syntax issue will be gone too.

这篇关于我在update语句中遇到错误语法错误，代码有什么问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！