Syntax Error Message on UPDATE of container field from LabVIEW using ODBC
Filemaker Pro Advanced 12.0v1
Operating system version
Win 7 Pro 32-bit
Description of the issue
I am attempting to upload JPEGs to a container field in a simple test data base using National Instruments LabVIEW with database connectivity toolkit using the ODBC drivers. I can UPDATE, INSERT, and SELECT all other field types and I can successfully read the contents of the container field using:
SELECT GetAs(Pic, 'JPEG') FROM PhotoTest WHERE Name ='Jeremy'
When I attempt to UPDATE the Pic field with a JPEG file string using
UPDATE PhotoTest SET PutAs(Pic, 'JPEG')=? WHERE Name ='Jeremy'
I get the following syntax error codes ADO 0x80040E09 and FQL0001/(1:22).
The LabVIEW database connectivity toolkit is creating a parameterized SQL query "under the hood" There is some generic syntax checking (by LabVIEW) that these queries pass prior to execution of the query and query syntax error.
I am a bit stuck. Is their anything in security/container formatting that I should look for?
Steps to reproduce the problem
(1) uploading Bitmaps (.SGI) and TIFFs with the same error message.
(2) resampling to a smaller image prior to update with the same error
Update of Pic container field
Exact text of any error message(s) that appear
ADO 0x80040E09 and FQL0001/(1:22)
I can attached the LabVIEW snippets if that is of any use but I suspect its not.