O'Hare - problem with last name 2

[andzejek]

here is the code:

Dim str_Last_Name as string

SQLstr = "Insert into Customer ([LAST_NAME]) Values('" & str_Last_Name & "');"

It is working fine but not for names like O'Hare. Can someone help me with that?

 

[jrbarnett]

You need to replace every single apostrophe ' with two apostrophes.

Dim str_Last_Name as string

str_last_name = Replace (str_last_name, "'", "''")

SQLstr = "Insert into Customer ([LAST_NAME]) Values('" & str_Last_Name & "');"

John

 

[lespaul]

The reason is because of the ' .... when you create your query string you end up with:

INSERT INTO Customer ([LAST NAME]) VALUES ([b]'[/b]O[b]'[/b]Hare[b]'[/b]);

Here's a solution that I found by searching the Access fora for apostrope in name...

sqlOut = "INSERT INTO tryit (myID) VALUES ('" & Replace(aEMPLID, "'", "''") & "')"

Leslie

Essential for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[andzejek]

Thank you!, it is working now!