AnsweredAssumed Answered

FM ODBC and containers

Question asked by TomMurray on Sep 23, 2015
Latest reply on Sep 23, 2015 by TSGal

[I think I should post this to a "product suggestions" forum but I looked hard and did not find one]


I've been joyfully using the FM-to-MySQL ODBC link for several years, using the driver by Actual. (I was thrilled that it works fine in WebDirect as well.)  Now I need to work with container fields, images, sound files, etc., and want to store those where everything else is stored, in mySQL. This feature is apparently not supported.  I wrote to Actual and they said the limitation was on the FM side.  Here is what the advisor at Actual said:

"As you have seen, blob / container fields are not supported with “External SQL Sources” (ESS).  We would welcome it if FM decided to support those fields in the future, but so far they have not implemented it within FM.  It’s possible to import a blob from a MySQL database into a container field using the “Import Records” script step, but I don’t know of any way to write the container field to the MySQL database."


Is this feature in the pipeline, and/or have other solutions been worked out?


--thanks, Tom