cannot insert values with single quote and double quote in it

[freiddann]

Hi!


I'm using ADO in VB and I'm having problems on inserting into tables field values with double quote and single quote in it...

these statements were ok:
insert into table1 (Field1) Values ("With Single (') Qoute&quot
insert into table1 (Field1) Values ('With Double (&quot Qoute')

now these are some problems:
insert into table1 (Field1) Values ('With both single and (')(&quotdouble quote')

insert into table1 (Field1) Values ("With both single and (')(&quotdouble quote&quot

can somebody help...
thanks...

 

[QatQat]

Freiddann,

read my answer to your other posting.

Bye

Qatqat

Life is what happens when you are making other plans.