AnsweredAssumed Answered

Syntax Error Message on UPDATE of container field from LabVIEW using ODBC

Question asked by JeremyHourigan on Jul 25, 2012
Latest reply on Jul 25, 2012 by JeremyHourigan

Summary

Syntax Error Message on UPDATE of container field from LabVIEW using ODBC

Product

FileMaker Pro

Version

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

I tried:
(1) uploading Bitmaps (.SGI) and TIFFs with the same error message. 
(2) resampling to a smaller image  prior to update with the same error

Expected result

Update of Pic container field

Actual result

Syntax Error

Exact text of any error message(s) that appear

ADO 0x80040E09 and FQL0001/(1:22)

Configuration information

I can attached the LabVIEW snippets if that is of any use but I suspect its not.

Workaround

None Yet

Outcomes