Quotes in database fields workaround 2

[Genotix]

Hi there,

Is there a way to "escape" certain reserved characters when they're put into a string which I want to insert in a database field?
The problem I have now is that VB6 gives me an error when i'm using a quote in the text field.

Thanx for your replies!

Eric

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[zemp]

see faq709-1526.

zemp

 

[pkailas]

Oh yes there is. use something like this

variable = replace(variable, "'", "''")

 

[zemp]

See also thread222-932658. Other threads can be found discussing this issue by using the search function.

zemp

 

[Genotix]

@Zemp

It's not that easy to use the search function when you're not that good in English.
I know how to phrase a question but find it very hard to use the right words in a search.

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[Genotix]

@pkailas

Thanx just wat I needed

Linux IS userfriendly.
It's only very selective about who it's friends are.