ODBC, Oracle and The Single Quote.

[GMandas]

I am trying to insert records into an Oracle ODBC data source. Unfortunately the text data has single as well as double quotes in it. I first tried exec SQL insert using a calculated query and I get miss matching quotes and therefore, “String not properly terminated” errors. I then attempted to create a related table as an external data source and got lost there too. I created a layout but all it says is “Unrelated Table”

Is there some easy way to sanitize the text data in a calculated insert query so the quotes match up or insert the data in such a manner it doesn’t care about the quotes (link the one I just typed in "doesn’t")?

Alternately, If I have an empty FMP table linked to an empty Oracle table, is there a way I can insert a record into FMP have it automatically inserted into the external Oracle table without using Execute SQL Insert and therefore getting around the problems with the calculated query?

Is there some other way to do this?

I am an FMP 5 user/developer new to FMP9 and ODBC.

Greg

[Musikman]

There is a great online tutorial to help you link your Filemaker DB with your Oracle Tables. You can find it at http://examples.oreilly.com/filemaker9tmm/screencasts/ess/screencast.html