synergyconsulting
asked on
error 3061
I have a simple update query, run from a form but does not contain form references, just table.fields. This runs fine in my test environment but fails when I run it in the production environment. I don't know of any difference in the two environments that would be related to this error (obviously, I'm missing something). A very similar query runs fine just before this one. I've tried removing the Where clause but the error (3061, Too few Parameters, Expected 1) still occurs.
Any suggestions will be greatly appreciated.
Thanks,
Brent
Any suggestions will be greatly appreciated.
Thanks,
Brent
'Update table from imported data
strSQL = "UPDATE [RouteCards_temp]" & _
" INNER JOIN StreetSyncOutput ON [RouteCards_temp].iCustId = StreetSyncOutput.CustomerNumber" & _
" SET [RouteCards_temp].Sequence = StreetSyncOutput.Sequence," & _
" [RouteCards_temp].StopSequence = StreetSyncOutput.StopSequence" & _
" [RouteCards_temp].RouteName = StreetSyncOutput.RouteName" & _
" WHERE RouteCards_temp.icustid > 0 ;"
db.Execute strSQL, dbFailOnError
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Same for table names. Just ensure that the database table structure is identical in both environments in addition to the actual code or SQL.
ASKER
I've requested that this question be deleted for the following reason:
I found my solution. Production database had a typo in a related field.
I found my solution. Production database had a typo in a related field.
<Production database had a typo in a related field.>
The comments here addressed that.
The comments here addressed that.
ASKER
typo in field name in prod database.
"Well, since there are no Form references and not WHERE issue, almost leaves a Typo"
Missing fields are another cause of this error.