Update statement

[Suha]

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.

 

 

[Wim Decorte]

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?

[Suha]

OC is the name of ODBC connection and DB! is the name of the data source I am using for the connection.

[Wim Decorte]

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?

[Suha]

Yes, I am using Execute SQL script step and It is working with Update statement.

Thank you.