At present we can't work with SQL Columns of type 'xml' when connecting up using ESS. This is a bit of a pain, it would be great to have native capability to manipulate these types of fields/columns using ESS natively.
Hi Chris,
The RDMS which led me to make this request would be MSSQL, but I guess the concept would carry across any platform.
There's been a fairly in-depth discussion on this topic here:
https://community.filemaker.com/message/561036?et=watches.email.thread#561036
I would particularly like to see support for Binary data fields, so we can store graphic, document and video content in SQL and access easily via Filemaker.
Which external RDMS? Can you define and attach a VIEW which converts it to text/varchar?