Connecting Tech Pros Worldwide Forums | Help | Site Map

Syntax Error in INSERT INTO Command

Samy K
Guest
 
Posts: n/a
#1: Nov 20 '05
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.OleDbDataAdapter
Dim CmdBuilder As OleDb.OleDbCommandBuilder
Dim ds As DataSet = New DataSet()
Dim table As DataTable
Dim row As DataRow

'sqlstring is global variable with string "Select
* from inv_compt_invest"
readwrite = New OleDb.OleDbDataAdapter(sqlstring,
dbInventaire)
CmdBuilder = New OleDb.OleDbCommandBuilder
(readwrite)
readwrite.InsertCommand =
CmdBuilder.GetInsertCommand()
MsgBox(readwrite.InsertCommand.CommandText)
Try
readwrite.Fill(ds, "inv_compt_invest")

'output data from dataset
table = ds.Tables.Item(0)
If table.Rows.Count <> 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("Designation de l'article") =
TextBox4.Text
row("Quantite") = CInt(TextBox5.Text)
row("Fournisseur") = TextBox6.Text
row("Num de la facture") =
TextBox7.Text
row("Marque") = TextBox8.Text
row("Localisation") = TextBox9.Text
table.Rows.Add(row)

'Update the database table
readwrite.Update
(ds, "inv_compt_invest") '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.Message)
End Try

thanks,

Sam

CT
Guest
 
Posts: n/a
#2: Nov 20 '05

re: Syntax Error in INSERT INTO Command


What database are you connecting to? Also, why do you call this line of code
readwrite.InsertCommand = CmdBuilder.GetInsertCommand()?


--
Carsten Thomsen

Enterprise Development with VS .NET, UML, and MSF
http://www.apress.com/book/bookDisplay.html?bID=105
"Samy K" <skourdes@hotmail.com> wrote in message
news:341101c3757a$b39c4a10$a101280a@phx.gbl...[color=blue]
> 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.OleDbDataAdapter
> Dim CmdBuilder As OleDb.OleDbCommandBuilder
> Dim ds As DataSet = New DataSet()
> Dim table As DataTable
> Dim row As DataRow
>
> 'sqlstring is global variable with string "Select
> * from inv_compt_invest"
> readwrite = New OleDb.OleDbDataAdapter(sqlstring,
> dbInventaire)
> CmdBuilder = New OleDb.OleDbCommandBuilder
> (readwrite)
> readwrite.InsertCommand =
> CmdBuilder.GetInsertCommand()
> MsgBox(readwrite.InsertCommand.CommandText)
> Try
> readwrite.Fill(ds, "inv_compt_invest")
>
> 'output data from dataset
> table = ds.Tables.Item(0)
> If table.Rows.Count <> 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("Designation de l'article") =
> TextBox4.Text
> row("Quantite") = CInt(TextBox5.Text)
> row("Fournisseur") = TextBox6.Text
> row("Num de la facture") =
> TextBox7.Text
> row("Marque") = TextBox8.Text
> row("Localisation") = TextBox9.Text
> table.Rows.Add(row)
>
> 'Update the database table
> readwrite.Update
> (ds, "inv_compt_invest") '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.Message)
> End Try
>
> thanks,
>
> Sam[/color]


Herfried K. Wagner [MVP]
Guest
 
Posts: n/a
#3: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hello,

"Samy K" <skourdes@hotmail.com> schrieb:[color=blue]
> 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:[/color]

This is a VB.NET language group. Please turn to the ADO.NET newsgroup:

news://msnews.microsoft.com/microsof...amework.adonet

Web interface:

http://msdn.microsoft.com/newsgroups...amework.adonet

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


Samy K
Guest
 
Posts: n/a
#4: Nov 20 '05

re: Syntax Error in INSERT INTO Command



I'm connecting to an access database locally on my
computer. I am using the CommandBuilder because I read
that it provides a mechanism to automatically generate
commands used to facilitate the updates made in an
OleDbDataSet to the corresponding table. If you give me
some points as to where the problem is occuring and why
it occurs that would be appreciated. Unfortunately I've
been told that this is not the right group to post. My
email to reply is skourdes@hotmail.com

thanks

Samy[color=blue]
>-----Original Message-----
>What database are you connecting to? Also, why do you[/color]
call this line of code[color=blue]
>readwrite.InsertCommand = CmdBuilder.GetInsertCommand()?
>
>
>--
>Carsten Thomsen
>
>Enterprise Development with VS .NET, UML, and MSF
>http://www.apress.com/book/bookDisplay.html?bID=105
>"Samy K" <skourdes@hotmail.com> wrote in message
>news:341101c3757a$b39c4a10$a101280a@phx.gbl...[color=green]
>> 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[/color][/color]
have[color=blue][color=green]
>> to assign certain values in my INSERT INTO SQL[/color][/color]
statement.[color=blue][color=green]
>> I have read about the commandbuilder and it said that[/color][/color]
the[color=blue][color=green]
>> insert command is automatically generated. Below is my
>> code. Can someone help me out into where the syntax[/color][/color]
error[color=blue][color=green]
>> is happening:
>>
>> Dim readwrite As OleDb.OleDbDataAdapter
>> Dim CmdBuilder As OleDb.OleDbCommandBuilder
>> Dim ds As DataSet = New DataSet()
>> Dim table As DataTable
>> Dim row As DataRow
>>
>> 'sqlstring is global variable with[/color][/color]
string "Select[color=blue][color=green]
>> * from inv_compt_invest"
>> readwrite = New OleDb.OleDbDataAdapter[/color][/color]
(sqlstring,[color=blue][color=green]
>> dbInventaire)
>> CmdBuilder = New OleDb.OleDbCommandBuilder
>> (readwrite)
>> readwrite.InsertCommand =
>> CmdBuilder.GetInsertCommand()
>> MsgBox(readwrite.InsertCommand.CommandText)
>> Try
>> readwrite.Fill(ds, "inv_compt_invest")
>>
>> 'output data from dataset
>> table = ds.Tables.Item(0)
>> If table.Rows.Count <> 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("Designation de l'article") =
>> TextBox4.Text
>> row("Quantite") = CInt[/color][/color]
(TextBox5.Text)[color=blue][color=green]
>> row("Fournisseur") = TextBox6.Text
>> row("Num de la facture") =
>> TextBox7.Text
>> row("Marque") = TextBox8.Text
>> row("Localisation") = TextBox9.Text
>> table.Rows.Add(row)
>>
>> 'Update the database table
>> readwrite.Update
>> (ds, "inv_compt_invest") 'The exception gets triggered
>> here through debugging
>> newdataentry = False
>> Else
>> MsgBox("Need to enter new data to[/color][/color]
save[color=blue][color=green]
>> to Database")
>> End If
>> End If
>> Catch ex As Exception
>> MsgBox(ex.Message)
>> End Try
>>
>> thanks,
>>
>> Sam[/color]
>
>
>.
>[/color]
Fergus Cooney
Guest
 
Posts: n/a
#5: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hi Samy,

You have to forgive Herfried - he doesn't mean to sound like a policeman..
It's just that his English is a bit terse at times.

When he says

|| This is a VB.NET language group.
|| Please turn to the ADO.NET newsgroup:",

what he really means is

Welcome to the languages.vb newsgroup. This newsgroup is really intended
for the VB.NET language and related issues. There are specialised newsgroups
for database queries and I feel you will get the best support possible by
going to one of these. The ADO.NET newsgroup can be found at
news://msnews.microsoft.com/microsof...amework.adonet. Go ahead
and post your question there. :-)

But that's far too much to copy and paste.

Now that you're here, though, and someone is responding to you, you might
as well continue.

Regards,
Fergus


Cor
Guest
 
Posts: n/a
#6: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Fergus,
Has it really to be that long.
Maybe you can find something in between, than Herfried can copy that in that
big archive of him.
:-)
Cor


Herfried K. Wagner [MVP]
Guest
 
Posts: n/a
#7: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hello,

"Fergus Cooney" <filter-1@tesco.net> schrieb:[color=blue]
> You have to forgive Herfried - he doesn't mean to sound like
> a policeman..
> It's just that his English is a bit terse at times.
>
> When he says
>
> || This is a VB.NET language group.
> || Please turn to the ADO.NET newsgroup:",
>
> what he really means is
>
> Welcome to the languages.vb newsgroup. This newsgroup is
> really intended for the VB.NET language and related issues.
> There are specialised newsgroups for database queries and I
> feel you will get the best support possible by going to one of
> these. The ADO.NET newsgroup can be found at
> news://msnews.microsoft.com/microsof...amework.adonet.[/color]

That's exactly what I mean.
[color=blue]
> But that's far too much to copy and paste.[/color]

Too much to *download*.

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


Fergus Cooney
Guest
 
Posts: n/a
#8: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hi Cor,

I copied that from one of the advisers in the dotnet.academic group. When
I first read it I thought that it was very well worded and full of
sensitivity. I don't think it's too long, myself. Remember, each person coming
here for the first time will be reading that as if it is a conversation to
them. They have the time to read a few sentences when it is politely telling
them that their presence is welcomed - but that it would be better for them to
try elsewhere.

<rant>

Unfortunately, I do believe that Herfried's and Armin's "This is vb.net..
Please go" iis actually short to the point of being rude. It implies that our
visitors are wrong to be here - not that they are welcome but we are not the
best people for them. To me it is better than "Not here. Go away", but not
hugely so.

I find reading the "This is vb.net.. Please go" messages more of a chore
than others do reading OT messages. This is simply because there have been so
many times when I or someone else <has> had an answer to the query. So what if
this is the wrong area? Maybe I or someone can help. Let us do so. We should
be telling visitors that if they get no response then elsewhere may be better
<for them>. We shouldn't be implying that they are trespassing on <our> sacred
ground.

It sometimes seems to me that Herfried and Armin are just waiting so that
they can jump on people who wander in here 'inappropriately'. And sometimes it
seems to be a race to see who can kick them out soonest.

Cor, I have training as a psychologist and therapist, so I am always
looking to be aware of how people will perceive what I'm typing to them. 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 misunderstanding, it is best to be clear. To soften, where
possible.

Sorry to get so heavy on this topic, Cor, but my feelings about this have
been getting stronger and stronger. I'm taking the opportunity to tell you, as
it allows me to say what I feel without having to address Herfried and Armin
directly. I've been getting close to doing so, but I like and admire them
both, and don't want to cause bad feeling. I'm sure that the rudeness that I
perceive isn't their intention. But I am certain that it is ignorance.

You can say that I'm being over sensitive. I <am> sensitive when it comes
to these sort of issues (but, hey, that's part of being a therapist). Many
times I'm probably being more careful than necessary. But it's the same
principle as in programming. How many error checks and exception handlers do
you insert 'just in case' - for errors you'd never really expect? That's
considered good, robust programming. Ditto with using more words than fewer
to communicate with friendliness.

</rant>

Thanks for listening to all this. :-)

Regards,
Fergus


Herfried K. Wagner [MVP]
Guest
 
Posts: n/a
#9: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hello,

"Fergus Cooney" <filter-1@tesco.net> schrieb:[color=blue]
> Remember, each person coming here for the first time will
> be reading that as if it is a conversation to them. They have the
> time to read a few sentences when it is politely telling them that
> their presence is welcomed - but that it would be better for them to
> try elsewhere.[/color]

That's theory.
[color=blue]
> Unfortunately, I do believe that Herfried's and Armin's
> "This is vb.net.. Please go" iis actually short to the point
> of being rude.[/color]

Mhm... In the German language, "please" ("bitte") is considered very
friendly and not rude.
[color=blue]
> It implies that our visitors are wrong to be here -[/color]

They _are_ wrong in this ng.
[color=blue]
> not that they are welcome but we are not the best people
> for them. To me it is better than "Not here. Go away", but not
> hugely so.[/color]

LOL
[color=blue]
> I find reading the "This is vb.net.. Please go" messages more
> of a chore than others do reading OT messages. This is simply
> because there have been so many times when I or someone
> else <has> had an answer to the query. So what if this is the
> wrong area?[/color]

If it's in the wrong ng, I tell the OP that he should post to a
more-suitable ng. Maybe this will prevent future postings in the wrong
ng.
[color=blue]
> Maybe I or someone can help. Let us do so.[/color]

Yep.
[color=blue]
> We should be telling visitors that if they get no response then
> elsewhere may be better <for them>. We shouldn't be implying that
> they are trespassing on <our> sacred ground.[/color]

That's _your_ interpretation. If you have a look at the replies to my
"go to..." postings, you will see that some posters say "thank you for
the hint" or something like that.
[color=blue]
> It sometimes seems to me that Herfried and Armin are just waiting
> so that they can jump on people who wander in here 'inappropriately'.[/color]

No.
[color=blue]
> And sometimes it seems to be a race to see who can kick
> them out soonest.[/color]

I don't kick anybody out.

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


Cor
Guest
 
Posts: n/a
#10: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hi Fergus,
I do it in Herfried style this time.
[color=blue]
> I copied that from one of the advisers in the dotnet.academic group.[/color]
When[color=blue]
> I first read it I thought that it was very well worded and full of
> sensitivity. I don't think it's too long, myself. Remember, each person[/color]
coming[color=blue]
> here for the first time will be reading that as if it is a conversation to
> them. They have the time to read a few sentences when it is politely[/color]
telling[color=blue]
> them that their presence is welcomed - but that it would be better for[/color]
them to[color=blue]
> try elsewhere.
>[/color]
First of all we agree totaly.
My Idea was that there are a lot of people visiting this newsgroup, for who
is the not abstract English not so easy to read. I think that we have to
keep that in mind. (Although it is normaly not a problem, they have the
documentation to read too and that is often in bad English).
Therefore I think it hat to be polite but short to the subject. Therefore
was my thought such a sentence can be best done by someone who is a real
Englishman. But maybe you can make it and Herfried, Armin and I can look it
over. Think about your sentence more bellow about the communication aspect.[color=blue]
>
> Unfortunately, I do believe that Herfried's and Armin's "This is[/color]
vb.net..[color=blue]
> Please go" iis actually short to the point of being rude. It implies that[/color]
our[color=blue]
> visitors are wrong to be here - not that they are welcome but we are not[/color]
the[color=blue]
> best people for them. To me it is better than "Not here. Go away", but not
> hugely so.[/color]

Yes 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.
[color=blue]
> I find reading the "This is vb.net.. Please go" messages more of a[/color]
chore[color=blue]
> than others do reading OT messages. This is simply because there have been[/color]
so[color=blue]
> many times when I or someone else <has> had an answer to the query. So[/color]
what if[color=blue]
> this is the wrong area? Maybe I or someone can help. Let us do so. We[/color]
should[color=blue]
> be telling visitors that if they get no response then elsewhere may be[/color]
better[color=blue]
> <for them>. We shouldn't be implying that they are trespassing on <our>[/color]
sacred[color=blue]
> ground.[/color]

Agree, but if there is a better place, we have too tell them that. And
sometimes it is so out of topic, that it is better not to help I think.
And then one of your so called Microsofties kickes on it in this newsgroup
and start helping about HTML, VB6 or IIS. :-(
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.
I think it has to do with good sence.
[color=blue]
> It sometimes seems to me that Herfried and Armin are just waiting so[/color]
that[color=blue]
> they can jump on people who wander in here 'inappropriately'. And[/color]
sometimes it[color=blue]
> seems to be a race to see who can kick them out soonest.
>[/color]
I sometimes too get that Idea, but not only Herfried and Armin.
Refering to JavaScript in a VB.net question means that they get a "Please
go" and the strangest is that when people only use C# in the same sentence
they will be direct helped.
[color=blue]
> Cor, I have training as a psychologist and therapist, so I am always
> looking to be aware of how people will perceive what I'm typing to them.[/color]
When[color=blue]
> you're dealing with a text-only communication - no faces, no expressions,[/color]
no[color=blue]
> 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[/color]
hint[color=blue]
> of the other person misunderstanding, it is best to be clear. To soften,[/color]
where[color=blue]
> possible.[/color]

I have not trained as a psycholist, but this is what I say for year and that
started with the begin of e-mail.[color=blue]
>
> Sorry to get so heavy on this topic, Cor, but my feelings about this[/color]
have[color=blue]
> been getting stronger and stronger. I'm taking the opportunity to tell[/color]
you, as[color=blue]
> it allows me to say what I feel without having to address Herfried and[/color]
Armin[color=blue]
> directly. I've been getting close to doing so, but I like and admire them
> both, and don't want to cause bad feeling. I'm sure that the rudeness that[/color]
I[color=blue]
> perceive isn't their intention. But I am certain that it is ignorance.[/color]

I think that this very on Topic, this is how we behave our self in this
newsgroup and not in a Mainthread.
I do absolute not think that it is for Herfried and Armin to be rude. Take a
look at the de.vbnet.language group.
That is totaly different but what Herfried did write. That is a very
diciplined group. But that has maybe to do with the way people from German
acts in oposite from people from cities like London and Amsterdam. People
from major cities from the world acts in a different way than people who are
not from those.[color=blue]
>
> You can say that I'm being over sensitive. I <am> sensitive when it[/color]
comes[color=blue]
> to these sort of issues (but, hey, that's part of being a therapist). Many
> times I'm probably being more careful than necessary. But it's the same
> principle as in programming. How many error checks and exception handlers[/color]
do[color=blue]
> you insert 'just in case' - for errors you'd never really expect? That's
> considered good, robust programming. Ditto with using more words than[/color]
fewer[color=blue]
> to communicate with friendliness.
>[/color]
I agree totaly, but is not always true I think, keep in mind that not
everybody understand non abstract English in this newsgroup.
Although reading is of course more easy than writing. Everybody who realy
makes programmes is sticked too use the English language for documentation.[color=blue]
>[/color]
I read most of your messages.
And thank you for reading my answers.
:)[color=blue]
>
> Regards,[/color]
Cor[color=blue]
>
>[/color]


Cor
Guest
 
Posts: n/a
#11: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Herfried,
Unfortanaly I did first answer Fergus and then read yours and Charles
answer.[color=blue]
>
> Mhm... In the German language, "please" ("bitte") is considered very
> friendly and not rude.
>[/color]
I did suspect that, see my message
:-)
Cor


Cor
Guest
 
Posts: n/a
#12: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Charles,
Unfortanaly I did first answer Fergus his message and than read the answers
from Herfried and You.[color=blue]
> I do realise though, that it's probably the
> case that whilst it is easy for people whose first language is English to[/color]
be[color=blue]
> verbose, it is less so for people for whom English is not their first
> language.
>[/color]
I did write it without first looking at your message, so we are thinking the
same about that.
:-)
Cor


Fergus Cooney
Guest
 
Posts: n/a
#13: Nov 20 '05

re: Syntax Error in INSERT INTO Command


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
|| > misunderstanding, 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
Guest
 
Posts: n/a
#14: Nov 20 '05

re: Syntax Error in INSERT INTO Command


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]
Guest
 
Posts: n/a
#15: Nov 20 '05

re: Syntax Error in INSERT INTO Command


Hello,

"Cor" <non@non.com> schrieb:[color=blue]
> 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.[/color]

I will use the text suggested by Fergus...

;-)

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


Closed Thread


Similar Visual Basic .NET bytes