Newbies Montechy Posted November 2, 2007 Newbies Share Posted November 2, 2007 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 More sharing options...
TimD Posted November 14, 2007 Share Posted November 14, 2007 Monty -- Try escaping the quote with another quote, like this: UPDATE Passes INSERT Last = 'O''Hare' WHERE PASSNO = '1234565' -- Tim Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6142 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 accountSign in
Already have an account? Sign in here.
Sign In Now