Jump to content

Updating Sql with ' in data?


This topic is 6066 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

Link to comment
Share on other sites

  • 2 weeks later...

This topic is 6066 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.