I don't believe so but I will check this when I get to the office. Thanks for the idea.
-----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard Quilhot Sent: 11 June 2014 05:07 To: [email protected] Subject: Re: ODBC Problem Is the test on the first row truncated? I've seen vfp set column width based on first record's data. Rick Q [email protected] On Tue, Jun 10, 2014 at 6:10 PM, Chris Davis <[email protected]> wrote: > Hi Dave > > It is FileMaker v11. I have setup a 32bit DSN. I can do the query > from both Excel and VFP using SPT. Excel displays the results fine, > VFP truncates the text. > > Thanks > > Chris. > > -----Original Message----- > From: ProfoxTech [mailto:[email protected]] On Behalf Of > Dave Crozier > Sent: 10 June 2014 10:27 > To: [email protected] > Subject: RE: ODBC Problem > > Which version of Filemaker? > > I have a small system here on V11 with VFP9 SP1 and ODBC works no > problem in both reading and writing data. I just inherited it from a > Filemaker V8 program and have just updated it as required. Don't > forget that by default if you are using 64bit Windows then the 64 bit > driver will be looked for and VFP only works with the 32 bit driver - > The same goes for the SQL Server ODBC driver. > > Dave > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Chris > Davis > Sent: 10 June 2014 10:09 > To: [email protected] > Subject: ODBC Problem > > Has anyone encountered any issues using ODBC with a third party product. > Query's via Excel work fine, via VFP they don't work full stop using > the the View designers and give random results using SQL Pass Through. > > Thanks > > Chris. > > The ODBC Driver in question is for Filemaker. > > ______________________________________________________________________ > This email has been scanned by the Symantec Email Security.cloud service. > For more information please visit http://www.symanteccloud.com > ______________________________________________________________________ > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
