Update data in Oracle using Filemaker

[Suha]

I am using Import script step to move data into Oracle database using ODBC connection. It is working if there is data/text in the field but it does not push blanks into fields in Oracle db. Any suggestions?

[Wim Decorte]

Import script step can only get data into FM.  If you are creating records or updating records in Oracle you should be using the Execute SQL script step...

Do you get any errors logged on the Oracle side?  Any field validations on the Oracle side where it would not accept empty values?

[beverly]

"Blanks" may require NULL. FMP doesn't know what NULL is.

and/or your columns may be NOT NULL and that is your error. Yes, log and look at the logs.