SQL Update question
in [Queries]
|
Prev: Free Live Voice and Video Chat!Connect with Over 4 Million Members download now
Next: deduct order quantity from credit limit
From: Afrosheen via AccessMonster.com on 2 Jun 2010 09:30 Good morning, I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are True/False fields. The printtab is a number field. In stead of having 3 SQL statements, I'd like to update the fields like this: strSQL = "UPDATE tblconfig SET [rotation] = True, [printtab] = 1, [adn] = True" '************* Updates the Config File ************* CurrentDb.Execute strSQL, dbFailOnError When I tried it it kept on giving me errors. Error:3061. Too few parameters. Expected 1. Can it be done like above or do I need to use 3 SQL statements? Thank you for your input. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201006/1
From: John Spencer on 2 Jun 2010 11:17 No, it can be done in one query. The error message indicates that one of the field names is incorrectly spelled or that True is being misunderstood for some reason. Try strSQL = "UPDATE tblconfig SET [rotation] = -1, [printtab] = 1, [adn] = -1" If that still gives you the same error, double check the spelling of the field names. John Spencer Access MVP 2002-2005, 2007-2010 The Hilltop Institute University of Maryland Baltimore County Afrosheen via AccessMonster.com wrote: > Good morning, > I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are > True/False fields. The printtab is a number field. > > In stead of having 3 SQL statements, I'd like to update the fields like this: > > strSQL = "UPDATE tblconfig SET [rotation] = True, [printtab] = 1, [adn] = > True" > > '************* Updates the Config File ************* > CurrentDb.Execute strSQL, dbFailOnError > > When I tried it it kept on giving me errors. > Error:3061. Too few parameters. Expected 1. > > Can it be done like above or do I need to use 3 SQL statements? > > Thank you for your input. >
From: Afrosheen via AccessMonster.com on 2 Jun 2010 12:14
Thanks for the quick come back. Your suggestion worked. I really appreciate the help There was a field error spelling problem. I should have used [printab] instead of [printtab] Thanks again for the direction. John Spencer wrote: >No, it can be done in one query. The error message indicates that one of the >field names is incorrectly spelled or that True is being misunderstood for >some reason. > >Try >strSQL = "UPDATE tblconfig SET [rotation] = -1, [printtab] = 1, [adn] = -1" > >If that still gives you the same error, double check the spelling of the field >names. > >John Spencer >Access MVP 2002-2005, 2007-2010 >The Hilltop Institute >University of Maryland Baltimore County > >> Good morning, >> I have 3 fields [printtab], [rotation], & [adn]. Rotation and adn are >[quoted text clipped - 14 lines] >> >> Thank you for your input. -- Message posted via http://www.accessmonster.com |