Syntax Error in INSERT INTO Command

[Samy K]

I'm having a bit of problems entering a new row to an
access database and what I would like to know is do I have
to assign certain values in my INSERT INTO SQL statement.
I have read about the commandbuilder and it said that the
insert command is automatically generated. Below is my
code. Can someone help me out into where the syntax error
is happening:

Dim readwrite As OleDb.OleDbData Adapter
Dim CmdBuilder As OleDb.OleDbComm andBuilder
Dim ds As DataSet = New DataSet()
Dim table As DataTable
Dim row As DataRow

'sqlstring is global variable with string "Select
* from inv_compt_inves t"
readwrite = New OleDb.OleDbData Adapter(sqlstri ng,
dbInventaire)
CmdBuilder = New OleDb.OleDbComm andBuilder
(readwrite)
readwrite.Inser tCommand =
CmdBuilder.GetI nsertCommand()
MsgBox(readwrit e.InsertCommand .CommandText)
Try
readwrite.Fill( ds, "inv_compt_inve st")

'output data from dataset
table = ds.Tables.Item( 0)
If table.Rows.Coun t <> 0 Then

'Enter new records
If newdataentry = True Then
row = table.NewRow()
row("Date d'acquisition") = CDate
(TextBox2.Text)
row("Num de Compte") = CInt
(TextBox3.Text)
row("Designatio n de l'article") =
TextBox4.Text
row("Quantite") = CInt(TextBox5.T ext)
row("Fournisseu r") = TextBox6.Text
row("Num de la facture") =
TextBox7.Text
row("Marque") = TextBox8.Text
row("Localisati on") = TextBox9.Text
table.Rows.Add( row)

'Update the database table
readwrite.Updat e
(ds, "inv_compt_inve st") 'The exception gets triggered
here through debugging
newdataentry = False
Else
MsgBox("Need to enter new data to save
to Database")
End If
End If
Catch ex As Exception
MsgBox(ex.Messa ge)
End Try

thanks,

Sam

[Cor]

Herfried,
Unfortanaly I did first answer Fergus and then read yours and Charles
answer.

Mhm... In the German language, "please" ("bitte") is considered very
friendly and not rude.

I did suspect that, see my message
:-)
Cor

[Cor]

Charles,
Unfortanaly I did first answer Fergus his message and than read the answers
from Herfried and You.

I do realise though, that it's probably the
case that whilst it is easy for people whose first language is English to be verbose, it is less so for people for whom English is not their first
language.

I did write it without first looking at your message, so we are thinking the
same about that.
:-)
Cor

[Fergus Cooney]

Hi Cor,

I posted this days ago, but to your personal email by mistake. Then I was
off for a few days helping my sister out. On return I discovered my message
returned to me. Here it is again - old news now but never mind. :-)
=============== =============== ====
Hi Cor,

I think this issue has been thoroughly covered but I want to respond to
you and thank you.

|| My idea was that there are a lot of people visiting this newsgroup,
|| for whom the more abstract English is not so easy to read [rephrased].

As said elsewhere, this is a good point for me to bear in mind. My English
ranges from gutter-speak (in off-topics) to fairly 'high brow' (abstract) -
with a fair smattering of idiom and slang. It would be interesting to know how
often I 'miss my target' because of this.

|| .. but that can be the difference in languages.
|| "Please go" is maybe in the English language much more
|| tyrrany than in German.
|| The word Please in this sentence is in my eyes too very bad
|| (in Dutch it is rude to use it in this way) I thought it is in English
|| the same. But maybe Herfried and Armin suspect that it is polite.

I agree. In English it is a polite word that can be used for exactly the
opposite effect. An example of that it the way I asked Stephany to
(effectively) "Please keep your nose out of our business". If you heard the
tone of voice that goes with <that 'please'> you'd not think I was being
polite!

|| ... if there is a better place, we have to tell them that.

I like your idea of giving it some time so that those with an answer can
give it. And then, if there is no replay, or perhaps in addition, a
redirection can be given. It is partly the rapidity which has caused me
distress.

|| And sometimes it is so out of topic, that it is better not to help ...
|| Giving long Helps on VB6 or Powerpoint questions makes that
|| this group becomes visited by a lot of people from there.
|| And after a while the people who have VB.net questions can not
|| find that questions anymore in the Google VB.net group.

This is a very good point. I want to help whoever I can, but there <is>
the possibility of this newsgroup getting a reputation as being generalist.
[Maybe I should move to dotnet.general but I like the people here. And the
questions, actually]. I have no sensible solution to this issue. Perhaps we
could issue 'tickets' to people - One OT question per email address. Any more
OT's and they get "The Severe Redirection"!! ;-) **

But then again, I'm not so sure that it would be a disaster. I would hope
that a well phrased Google search would only pull out relevant posts. I think
that people who visit for answers are of two main types - those with a query
and once they've got it they're off. They aren't particularly interested in
other posts, and those who just browse. Some of the latter may find cause for
concern.

|| Other points.

We are much in agreement. As I implied elsewhere, my Irish blood was
stirred up by the confrontations with Jack and Stephany. Thank you for
accepting my views and expressing them without the annoyance that I was
feeling.

Cor, you've been very good, very conciliatory*. You show great care for
us. :-D

|| > When you're dealing with a text-only communication - no faces,
|| > no expressions, no gestures, no tone of voice - it is important to
|| > be very careful how you express yourself. That's why I use :-)
|| > so much. Whenever there is even a hint of the other person
|| > misunderstandin g, it is best to be clear. To soften,
|| > where possible.
||
|| I have not trained as a psychologist, but this is what I say for
|| year and that started with the begin of e-mail

Some people are naturals. If you ever get fed up with programming, you
might take up counselling! ;-)

Regards,
Fergus

=============== =======
**
The Severe Redirection
"You've had your OT question - now GET LOST!!
And <don't> come back unless you've got a VB.NET question!!"

* conciliatory - [from 'to conciliate; 'reconciliation ']. In this instance -
one who seeks good will for all, and acceptance on all sides.

[Cor]

Fergus,
You understand it, I was curious about your answer on this message.
I've seen Herfried started to do like we did talk about and Armin in a way
too.
You can see Armin takes more time to write text like he does in the German
newsgroup.
Thanks for your answer,
Cor

[Herfried K. Wagner [MVP]]

Hello,

"Cor" <no*@non.com> schrieb:

You understand it, I was curious about your answer on
this message. I've seen Herfried started to do like we did
talk about and Armin in a way too.

I will use the text suggested by Fergus...

;-)

--
Herfried K. Wagner
MVP · VB Classic, VB.NET
http://www.mvps.org/dotnet