| Groups | Blog | Home |
dotnet ado.net : 'INSERT INTO' in Access
I wrote the code to insert a new record into an Access database. I get no errors. However a new record is not inserted. Any ideas? Please help. Thanks.Emil.
On Error resume next ? No dbFailOnError option ? What if the query is
executed as an action query ? Does the Access UI show then an error ? "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... [quoted text, click to view] > Hi. > > I wrote the code to insert a new record into an Access database. I get no > errors. However a new record is not inserted. > Any ideas? > > Please help. > Thanks.Emil. >
Sorry I'm not sure what I thought this question was in an Access group ;-)
You may want also to check that the SELECT part of your statement does return records (note for example that the wildcard character is % instead of *). Showing us some code could perhaps helps... "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... [quoted text, click to view] > Hi. > > I wrote the code to insert a new record into an Access database. I get no > errors. However a new record is not inserted. > Any ideas? > > Please help. > Thanks.Emil. >
forgot to mention that command is sent from my c# application.
Emil. [quoted text, click to view] "Patrice" <http://www.chez.com/scribe/> wrote in message news:uJf0JcIkHHA.4676@TK2MSFTNGP02.phx.gbl... > Sorry I'm not sure what I thought this question was in an Access group ;-) > > You may want also to check that the SELECT part of your statement does > return records (note for example that the wildcard character is % instead > of *). > > Showing us some code could perhaps helps... > > > "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: > ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >> Hi. >> >> I wrote the code to insert a new record into an Access database. I get no >> errors. However a new record is not inserted. >> Any ideas? >> >> Please help. >> Thanks.Emil. >> > >
What does code look like?
-- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ [quoted text, click to view] "EmilH" <emilslx@yahoo.com> wrote in message
news:ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... > Hi. > > I wrote the code to insert a new record into an Access database. I get no > errors. However a new record is not inserted. > Any ideas? > > Please help. > Thanks.Emil. >
here is the code:
command.CommandText = "INSERT Category (Name, Interval, Quantity) VALUES(\"" + categoryTB.Text + "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text + "\")"; oledb.Open(); command.ExecuteNonQuery(); oledb.Close(); Emil. [quoted text, click to view] "Miha Markic" <miha at rthand com> wrote in message news:uJR9ciIkHHA.4872@TK2MSFTNGP03.phx.gbl... > What does code look like? > > -- > Miha Markic [MVP C#, INETA Country Leader for Slovenia] > RightHand .NET consulting & development www.rthand.com > Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > > "EmilH" <emilslx@yahoo.com> wrote in message > news:ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >> Hi. >> >> I wrote the code to insert a new record into an Access database. I get no >> errors. However a new record is not inserted. >> Any ideas? >> >> Please help. >> Thanks.Emil. >> >
Also a common cause is if the db file is copied as part of the project
output directory. That is the db file that is in your project is left unchanged, you just update a copy... "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: efeDxhIkHHA.4032@TK2MSFTNGP02.phx.gbl... [quoted text, click to view] > forgot to mention that command is sent from my c# application. > Emil. > > "Patrice" <http://www.chez.com/scribe/> wrote in message > news:uJf0JcIkHHA.4676@TK2MSFTNGP02.phx.gbl... >> Sorry I'm not sure what I thought this question was in an Access group >> ;-) >> >> You may want also to check that the SELECT part of your statement does >> return records (note for example that the wildcard character is % instead >> of *). >> >> Showing us some code could perhaps helps... >> >> >> "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: >> ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >>> Hi. >>> >>> I wrote the code to insert a new record into an Access database. I get >>> no errors. However a new record is not inserted. >>> Any ideas? >>> >>> Please help. >>> Thanks.Emil. >>> >> >> > >
[quoted text, click to view]
On Mon, 7 May 2007 14:23:57 +0500, "EmilH" <emilslx@yahoo.com> wrote: ¤ here is the code: ¤ ¤ command.CommandText = "INSERT Category (Name, Interval, Quantity) VALUES(\"" ¤ + categoryTB.Text + ¤ ¤ "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text + ¤ "\")"; ¤ ¤ oledb.Open(); ¤ ¤ command.ExecuteNonQuery(); ¤ ¤ oledb.Close(); ¤ Name is a reserved word and must be enclosed within brackets. Paul ~~~~
[quoted text, click to view]
On Mon, 7 May 2007 18:49:38 +0200, "Miha Markic" <miha at rthand com> wrote: ¤ > ¤ here is the code: ¤ > ¤ ¤ > ¤ command.CommandText = "INSERT Category (Name, Interval, Quantity) ¤ > VALUES(\"" ¤ > ¤ + categoryTB.Text + ¤ > ¤ ¤ > ¤ "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text ¤ > + ¤ > ¤ "\")"; ¤ > ¤ ¤ > ¤ oledb.Open(); ¤ > ¤ ¤ > ¤ command.ExecuteNonQuery(); ¤ > ¤ ¤ > ¤ oledb.Close(); ¤ > ¤ ¤ > ¤ > Name is a reserved word and must be enclosed within brackets. ¤ ¤ This sql statement is starting to be like a picture where you have to find ¤ all the differences :-) Something tells me he's bypassing the exceptions as well. ;-) Paul ~~~~
Hi Emil,
Shouldn't it be INSERT *INTO* Category? -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/ [quoted text, click to view] "EmilH" <emilslx@yahoo.com> wrote in message
news:O0$kBmIkHHA.4768@TK2MSFTNGP05.phx.gbl... > here is the code: > > command.CommandText = "INSERT Category (Name, Interval, Quantity) > VALUES(\"" + categoryTB.Text + > > "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text + > "\")"; > > oledb.Open(); > > command.ExecuteNonQuery(); > > oledb.Close(); > > > > Emil. > > > "Miha Markic" <miha at rthand com> wrote in message > news:uJR9ciIkHHA.4872@TK2MSFTNGP03.phx.gbl... >> What does code look like? >> >> -- >> Miha Markic [MVP C#, INETA Country Leader for Slovenia] >> RightHand .NET consulting & development www.rthand.com >> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ >> >> "EmilH" <emilslx@yahoo.com> wrote in message >> news:ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >>> Hi. >>> >>> I wrote the code to insert a new record into an Access database. I get >>> no errors. However a new record is not inserted. >>> Any ideas? >>> >>> Please help. >>> Thanks.Emil. >>> >> > >
To add to Miha advice, I would also double check the code to see if it
doesn't currently hide some exceptions. IMO it shouldn't fail silently... "Miha Markic" <miha at rthand com> a écrit dans le message de news: eEAfYrJkHHA.3120@TK2MSFTNGP05.phx.gbl... [quoted text, click to view] > Hi Emil, > > Shouldn't it be INSERT *INTO* Category? > > -- > Miha Markic [MVP C#, INETA Country Leader for Slovenia] > RightHand .NET consulting & development www.rthand.com > Blog: http://cs.rthand.com/blogs/blog_with_righthand/ > "EmilH" <emilslx@yahoo.com> wrote in message > news:O0$kBmIkHHA.4768@TK2MSFTNGP05.phx.gbl... >> here is the code: >> >> command.CommandText = "INSERT Category (Name, Interval, Quantity) >> VALUES(\"" + categoryTB.Text + >> >> "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text + >> "\")"; >> >> oledb.Open(); >> >> command.ExecuteNonQuery(); >> >> oledb.Close(); >> >> >> >> Emil. >> >> >> "Miha Markic" <miha at rthand com> wrote in message >> news:uJR9ciIkHHA.4872@TK2MSFTNGP03.phx.gbl... >>> What does code look like? >>> >>> -- >>> Miha Markic [MVP C#, INETA Country Leader for Slovenia] >>> RightHand .NET consulting & development www.rthand.com >>> Blog: http://cs.rthand.com/blogs/blog_with_righthand/ >>> >>> "EmilH" <emilslx@yahoo.com> wrote in message >>> news:ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >>>> Hi. >>>> >>>> I wrote the code to insert a new record into an Access database. I get >>>> no errors. However a new record is not inserted. >>>> Any ideas? >>>> >>>> Please help. >>>> Thanks.Emil. >>>> >>> >> >> >
Good point, but it didn't help. Thanks anyway!
Emil. [quoted text, click to view] "Patrice" <http://www.chez.com/scribe/> wrote in message news:%232VPpwIkHHA.5024@TK2MSFTNGP06.phx.gbl... > Also a common cause is if the db file is copied as part of the project > output directory. That is the db file that is in your project is left > unchanged, you just update a copy... > > "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: > efeDxhIkHHA.4032@TK2MSFTNGP02.phx.gbl... >> forgot to mention that command is sent from my c# application. >> Emil. >> >> "Patrice" <http://www.chez.com/scribe/> wrote in message >> news:uJf0JcIkHHA.4676@TK2MSFTNGP02.phx.gbl... >>> Sorry I'm not sure what I thought this question was in an Access group >>> ;-) >>> >>> You may want also to check that the SELECT part of your statement does >>> return records (note for example that the wildcard character is % >>> instead of *). >>> >>> Showing us some code could perhaps helps... >>> >>> >>> "EmilH" <emilslx@yahoo.com> a écrit dans le message de news: >>> ufnFC$HkHHA.3472@TK2MSFTNGP04.phx.gbl... >>>> Hi. >>>> >>>> I wrote the code to insert a new record into an Access database. I get >>>> no errors. However a new record is not inserted. >>>> Any ideas? >>>> >>>> Please help. >>>> Thanks.Emil. >>>> >>> >>> >> >> > >
[quoted text, click to view] "Paul Clement" <UseAdddressAtEndofMessage@swspectrum.com> wrote in message news:4aeu33daqhepfknm7mupig5n23hv1046io@4ax.com... > On Mon, 7 May 2007 14:23:57 +0500, "EmilH" <emilslx@yahoo.com> wrote: > > ¤ here is the code: > ¤ > ¤ command.CommandText = "INSERT Category (Name, Interval, Quantity) > VALUES(\"" > ¤ + categoryTB.Text + > ¤ > ¤ "\",\"" + interimCB.SelectedItem.ToString() + "\",\"" + quantityTB.Text > + > ¤ "\")"; > ¤ > ¤ oledb.Open(); > ¤ > ¤ command.ExecuteNonQuery(); > ¤ > ¤ oledb.Close(); > ¤ > > Name is a reserved word and must be enclosed within brackets. This sql statement is starting to be like a picture where you have to find all the differences :-) -- Miha Markic [MVP C#, INETA Country Leader for Slovenia] RightHand .NET consulting & development www.rthand.com Blog: http://cs.rthand.com/blogs/blog_with_righthand/
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
| home · blog · groups | Questions? Comments? Contact the dn |