Insert into Statement

[kshah1579]

Hello experts,

I have made simple data entry screen, it works properly. I have done connectivity vb and ms sql 7.0. But i need to insert single invertedcoma sign( ' ) at data entry time from one text box. It gives me error "Incorrect syntex near ' " I amusing wondows xp.

Please give me answer as soon as possibel.

Ketan

[PEB]

Hi,

You can try to create a user defined procedure that replaces for exemple this combination :<ap> with '

Before you pass your string into a query you have to convert all ' in <ap> and in your query you have also to include your procedure!

:)