AnsweredAssumed Answered

Saving an image to a container field (and it's name) using JDBC

Question asked by MorkAfur on Aug 31, 2012
Latest reply on Apr 29, 2013 by pm

Title

Saving an image to a container field (and it's name) using JDBC

Post

I have code that, currently, writes the image data from a JPEG on the desktop to a container field in FMP 12. That part's fine.

What I can't figure out yet how to do is to also set the image NAME.

When I extract the image data from the database, I use two SQL statements defined in the excellent FMP JDBC programming manual: 1 for the image name, the other for the image data. When I tried to reverse this to write the image data back to the container field with the file name too, it doesn't work. What happens is that which ever is the second statement overwrites whatever the first statement did.

For those looking to do this too, this link gets you fairly close: http://www.skeletonkey.com/FileMaker_Container_Fields_JDBC

I would really appreciate any ideas or examples on how best to save both the image data (which I can do now) and also, at the same time, set the image name in the container field using JDBC.

Thanks in advance,
-m

Outcomes