I have an problem that I am looking for a more elegant solution for.
I import image data from a MS SQL Server into FM12 via an ODBC connection. The image data successfully makes the transition, but shows up only as "Untitled.dat" within the container.
My inelegant solution to this point has been to export the data locally (on the client) and then reimport it. After that, the image displays in the container field as expected.
This is clunky, and I am trying to figure out a way to do this in memory or maybe on the FM Server on demand.
Is there any way to grab the contents of a container into a variable and reinsert it into a container field to acheive this?