-
Could anyone tell me if there is any limit to the number of the fields that UPDATE command can update? I have a problem where the code below faild with the run time error 3144 (Syntax error in UPDATE statement), whereas if I take some of the fields out, it works.
SQLString = "UPDATE StationDet2 " _
& "SET NoRegularA = " & Check1 & ", " _
& "NoRegularB = " & Check2 & ", " _
& "NoRegularC = " & Check3 & ", " _
& "SuperS = " & Distributori(0) & ", " _
& "SuperD = " & Distributori(1) & ", " _
& "SuperM = " & Distributori(2) & ", " _
& "SSpbS = " & Distributori(3) & ", " _
& "SSpbD = " & Distributori(4) & ", " _
& "SSpbM = " & Distributori(5) & ", " _
& "GasolioS = " & Distributori(6) & ", " _
& "GasolioD = " & Distributori(7) & ", " _
& "GasolioM = " & Distributori(8) & ", " _
& "GPLS = " & Distributori(9) & ", " _
& "GPLD = " & Distributori(10) & ", " _
& "MetanoS = " & Distributori(11) & ", " _
& "MetanoD = " & Distributori(12) & " " _
& "WHERE Station_ID = " & wkStationID(ListChoice) & ";"
db.Execute SQLString
-
Check the fields that you removed. Could any of those be an empty string? That would give a syntax error.
The number of columns updated (as in your query )should as such not give any problems.
-
hmm
Are there more than 255 chars being stuffed in SQLSTRING variable?
-
There is a limit to the string size of the sql statement. You can, of course, get around this by executing multiple updates.
