Replace

[Tony]

Win XP Pro - access 2002 - vs 2002 - vb

Can someone tell me why this doesn't work?

Dim MyString as string
MyString = "Winner's"
Mystring.replac e("'", " ")
I'm trying to remove any single quotes from my data, so I don't get Sql
query errors.
It doesn't really matter what values I look for, the replace seems to do
nothing .

I also tried Dim MyString as Stringbuilder and system.stringbu ilder but I
just get errors Stringbuilder.
I did see this in the help, Dim MyString as Stringbuilder , but I'm unable
to replicate it?

Tony

[Stephany Young]

Have another read of the documentation for String.Replace.

The method returns the result of the Replace operation but, in you case, you
are not retaining the result.
"Tony" <To************ @msn.com> wrote in message
news:%2******** ********@TK2MSF TNGP09.phx.gbl. ..

Win XP Pro - access 2002 - vs 2002 - vb

Can someone tell me why this doesn't work?

Dim MyString as string
MyString = "Winner's"
Mystring.replac e("'", " ")
I'm trying to remove any single quotes from my data, so I don't get Sql
query errors.
It doesn't really matter what values I look for, the replace seems to do
nothing .

I also tried Dim MyString as Stringbuilder and system.stringbu ilder but I
just get errors Stringbuilder.
I did see this in the help, Dim MyString as Stringbuilder , but I'm unable
to replicate it?

Tony

[Cor Ligthert]

Tony,

To translate Stephany's words in code.

MyString = "Winner's"

MyString = Mystring.replac e("'", " ")

Cor

[Stephany Young]

What I was really saying to him Cor, was:

Read (and re-read if necessary) and make sure you understand how the
string.Replace method works.

Show someone how to find the answer and thay will learn.
Provide them with with the answer and they won't.
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:%2******** *******@TK2MSFT NGP10.phx.gbl.. .

Tony,

To translate Stephany's words in code.

MyString = "Winner's"

MyString = Mystring.replac e("'", " ")

Cor

[Cor Ligthert]

Stephany,

I know it was not critique, however a little sample learn sometimes people
easier to fish.

:-)

Cor

[Stephany Young]

Au contraire!

10 to 1 he copies and pastes the line you supplies and nevers thinks about
it again.
"Cor Ligthert" <no************ @planet.nl> wrote in message
news:Ot******** *****@TK2MSFTNG P10.phx.gbl...

Stephany,

I know it was not critique, however a little sample learn sometimes people
easier to fish.

:-)

Cor

[Cor Ligthert]

Stephany,

10 to 1 he copies and pastes the line you supplies and nevers thinks about
it again.

You can be right, however it has no sense to try to learn someone to fish
when he does not want to learn it. The evolution learns us that those
specimen don't exist long.

However the sample was only to renforce your text not en contraire of that.

:-)

Cor

[Herfried K. Wagner [MVP]]

"Tony" <To************ @msn.com> schrieb:

Can someone tell me why this doesn't work?

Dim MyString as string
MyString = "Winner's"
Mystring.replac e("'", " ")
'String.Replace ' will /return/ the resulting string! The sample below
demonstrates the use of the 'String.Replace ' method and VB.NET's
'Strings.Replac e' function which can be used alternatively:

\\\
Dim Text As String = "Fred's car"
Dim Result As String = Text.Replace("' ", "")
MsgBox(Result)
Result = Replace(Text, "'", "")
MsgBox(Result)
///
I'm trying to remove any single quotes from my data, so I don't get Sql
query errors.
It doesn't really matter what values I look for, the replace seems to do
nothing .
Instead of preparing the strings yourself and building the whole SQL command
string, you may want to use a parameterized command that will do the
escaping automatically:

Using Parameters with a 'DataAdapter'
<URL:http://msdn.microsoft. com/library/en-us/cpguide/html/cpconusingparam eterswithdataad apters.asp>
I also tried Dim MyString as Stringbuilder and system.stringbu ilder but I
just get errors Stringbuilder.

Add 'Imports System.Text' on top of your file.

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://classicvb.org/petition/>

[Tony]

I thank everyone for the help.
I didn't copy and paste.
I did the below which works just fine.

Dim QM as chr(39)
Do Until InStr(TransDesc ription, QM) = 0
Mid(TransDescri ption, InStr(TransDesc ription, QM), 1) = " "
Loop

But I think I will replace it with

TransDescriptio n=Transdescript ion.replace("'" ," ")

And I will look into the parameterized command url (hope it has examples!)

Could you imagine a world where learning by example wasn't allowed?

Thanks again



"Cor Ligthert" <no************ @planet.nl> wrote in message
news:OU******** ******@TK2MSFTN GP10.phx.gbl...

Stephany,

10 to 1 he copies and pastes the line you supplies and nevers thinks
about it again.

You can be right, however it has no sense to try to learn someone to fish
when he does not want to learn it. The evolution learns us that those
specimen don't exist long.

However the sample was only to renforce your text not en contraire of
that.

:-)

Cor

[Zanna]

"Tony" <To************ @msn.com> ha scritto nel messaggio
news:#v******** ******@TK2MSFTN GP09.phx.gbl...

Can someone tell me why this doesn't work?

Dim MyString as string
MyString = "Winner's"
Mystring.replac e("'", " ")
I'm trying to remove any single quotes from my data, so I don't get Sql
query errors.

for Sql statements you should *double* the quote, not remove them!

Mystring = Mystring.replac e("'", "''")

--
Reporting tool: http://www.neodatatype.net