Urgent -Not able to update record

[karunakaran]

Hi all,
I am not able to update a record with the following type.
Front end VB6.
Database access.

Table about company.
fields. id(number), companyname(text),status(text)

If I update a record without "'" symbol in the company name field everything works fine.

But if I give the company name like " ONG'S " in the update state ment it strucks. It is giving some syntax error in the SQL statement.

Anyone please help me how to over come with this "'" symbol to include in a company name.
when I hardcode it, I am able to do it.But I am not able to pass this as a parameter.

[Mark Sreeves]

For God's sake man I replied to you in thread:

http://forums.vb-world.net/showthrea...threadid=14056

ok so here's the update code:

strSQL = "UPDATE table1 SET colour1 = " & Quote & Text1.Text & Quote & ";"