Having an issue with SQL UPDATE and FileMaker.

 

My solution accesses several existing SQL tables via ESS. I have succesfully created scripts that access existing stored procedures in order to pull data or insert new rows. The trouble comes when trying to UPDATE rows.

 

The SQL rowversion value is required in order to execute our stored procedeures that update rows. IOW, in order to update the row, I have get the existing rowversion value, and pass it back with the updates. However I can't seem to access the rowversion column via FileMaker.  It exists in all of our SQL tables, yet is not avaialble in any FileMaker ESS shadow table. I have not been able to return a rowversion value to FileMaker variable via a direct table query either.

 

Any ideas?  

We are getting around this by writing a web service for FileMaker to call, and we will get the value into FileMaker as a JSON string. Still disappointing that FileMaker can't seem to handle that data type natively. (Unless we are missing something, which is certainly possible.)

Have you seen the ODBC/JDBC guide that's in stalled with FMP?

 

Chapter 7 details the supported standards - maybe there's something in there.

I found the answer. That data type (bottom of table in link) is simply "unsupported."

 

http://help.filemaker.com/app/answers/detail/a_id/6425/~/datatypes-and-field-mapping-with-filemaker