Updating Sql with ' in data?

[Montechy]

Greetings,

I am using Fm 9 advanced to import data from a MS Sql server, process it and return updated info to the Sql Server.

The problem I have run into is when trying to update a field with information that contains a "'".

Example being LastName is O'Hare. When using the executeSql script step to update the info (Sql Query is from a calc field) I get an error 5.

The calculated script looks like this

UPDATE Passes INSERT Last = 'O'Hare' WHERE PASSNO = '1234565'

If I change the last name to "O Hare" it works fine.

Obviously the problem is not the SQL server not being able to process it because the "O'Hare" came from the Sql database. Thus placed in there by the record creating program.

Other possibly relavent info

MAC Osx 10.4.10

Actuall Technology Sql driver for Filemaker

Any Ideas would be great!

Thanks

Monty

[TimD]

Monty --

Try escaping the quote with another quote, like this:

UPDATE Passes INSERT Last = 'O''Hare' WHERE PASSNO = '1234565'

-- Tim