2 Replies Latest reply on Jul 25, 2012 12:30 PM by JeremyHourigan

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

    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