Jump to content

Update statement


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

Recommended Posts

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_e
Set 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

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

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

This topic is 3108 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.