AnsweredAssumed Answered

ODBC Call hangs on long text fields

Question asked by wendto on Jan 10, 2013

Summary

ODBC Call hangs on long text fields

Product

FileMaker Pro

Version

FileMaker 12 Pro Advanced

Operating system version

Windows 7/8

Description of the issue

When accessing the FileMaker database via ODBC, a simple query hangs when the targeted field has more than 2047 characters.

Example:  Select FirstName, LastName, Signature From Customer

All three fields are TEXT type.  Signature contains text data that is greater than 2047 characters.  If I run this query on shorter text fields, I get the results I expect.  If I run it on fields with values over this limit the query hangs.

Steps to reproduce the problem

Create a simple aspx page with the following code:

<%@ Import Namespace="System.Data.odbc" %>







<!DOCTYPE html>

   
        Retrieve Signature Capture Data from FileMaker 12
       

   
   



           
                       

               
                   

                   
                   
                   
                   
                   
               
First NameLast NameSignature


               
                   
                    <%#Container.DataItem("FirstName")%>
                    <%#Container.DataItem("LastName")%>
                    <%#Container.DataItem("Signature")%>
                   
               


               
                   

               


           



           






Expected result

All text results returned from all fields specified even if the contents are over this 2046 limit.

Actual result

Any Text fields greater than 2046 characters = hangs query.

All Text fields less than 2046 characters = successful execution

Outcomes