Hi,
if we have a single quote in the string then the whole string makes problem when we save that string in the Database.

Dim myString as String
myString = "Shahzad's Car is in the workshop."

Thanks.

: Hi,
: if we have a single quote in the string then the whole string makes problem when we save that string in the Database.
:
:

: Dim myString as String
: myString = "Shahzad's Car is in the workshop."
: 

:
: Thanks.
:
I think you can solve the above problem by using the Replace function.
Replace(string,"'","''")
Thanks,
Jayesh.S

: : Hi,
: : if we have a single quote in the string then the whole string makes problem when we save that string in the Database.
: :
: :

: : Dim myString as String
: : myString = "Shahzad's Car is in the workshop."
: : 

: :
: : Thanks.
: :
: I think you can solve the above problem by using the Replace function.
: Replace(string,"'","''")
: Thanks,
: Jayesh.S
:
Thats a better solution but is there is any way to use single quote, because i want to save conversation between two or more persons and in this conversation single quote is used many times.
Thanks.

This message was edited by DrMarten at 2006-2-16 4:34:48

---

: Hi,
: if we have a single quote in the string then the whole string makes problem when we save that string in the Database.
:
:

: Dim myString as String
: myString = "Shahzad's Car is in the workshop."
: 

:
: Thanks.
:

==============================================


myString = "Shahzad" & CHR(39) & "s Car is in the workshop."


What problem does it give you in a database?
You could possibly use an array of type String like>


Dim carStatus(10) As String
'Counting in array i think starts at zero so you have 11 elements there.
carStatus(0)="Shahzad" & CHR(39) & "s Car is in the workshop."



Regards,

Dr M.