>I know when we have ' we have to double it, there is another caracter that i have to double ????
>and what i do with the :
>thanks !
There are no characters you have to double if you use parametric insertions vs hardcoded. ie:
lcName = "O'hara"
SQLExec(m.lnHandle, "insert into myTable (myName) values (?m.lcName)")
Cetin