Suha Posted August 22, 2015 Share Posted August 22, 2015 Why I am receiving this error "invalid character" when I am trying to update some records using this statement in FileMaker (it is working on oracle side but when I run it through FM ): ExecuteSQL(OC;DB1;"Update cost.ct_eSet Seg=N'"& $$Seg &"'Where Cn=N'" & $$CNo &"' ;") The variables are text: $$Seg=test1 and $$CNo=test1.test2. OC is the name of the ODBC connection and DB1 is the database. Link to comment Share on other sites More sharing options...
Wim Decorte Posted August 22, 2015 Share Posted August 22, 2015 You can not use ExecuteSQL() to run an UPDATE statement. Only SELECT is supported. Also structure of what you put into the ExecuteSQL() function seems totally wrong. What's your assumption there for hat OC and DB1 means? Link to comment Share on other sites More sharing options...
Suha Posted August 24, 2015 Author Share Posted August 24, 2015 OC is the name of ODBC connection and DB! is the name of the data source I am using for the connection. Link to comment Share on other sites More sharing options...
Wim Decorte Posted August 24, 2015 Share Posted August 24, 2015 The ExecuteSQL() function can only be used for SELECTs against the FM database itself, it does not require an ODBC connection. The Execute SQL script step (note the slightly different name, space and all) is the one that you are after. Is that what you are using? Link to comment Share on other sites More sharing options...
Suha Posted August 28, 2015 Author Share Posted August 28, 2015 Yes, I am using Execute SQL script step and It is working with Update statement. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 3291 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