Re: General field?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Fred Taylor (ftaylor_at_mvps.org!REMOVE)
Date: 03/09/05


Date: Wed, 9 Mar 2005 00:14:05 -0700

Which version of the ODBC driver are you using? I must say I've never seen
ODBC automatically convert a Memo field of any type to General.

-- 
Fred
Microsoft Visual FoxPro MVP
"howard" <howard@discussions.microsoft.com> wrote in message 
news:FA3CFC78-D749-4C91-A9A2-3E909997EDA4@microsoft.com...
> Fred, tnx for the response.  I am accessing the data from a VFP dbf (free
> table) The field is actually a Memo (binary) type field.  And yes, odbc
> returns this field as a Gen type field which I can't do anything with...
>
> In looking through this site, I noticed a lot of other folks are having
> problems managing graphics data in VFP tables
>
> "Fred Taylor" wrote:
>
>> Sounds like you've actually stored it in a General type field, as ODBC 
>> would
>> not automatically convert a Memo field to General.  What/where are you
>> trying to access the data from?
>>
>> -- 
>> Fred
>> Microsoft Visual FoxPro MVP
>>
>>
>> "howard" <howard@discussions.microsoft.com> wrote in message
>> news:B9AAB7F7-C278-496C-8A1F-F2A32D1C5B7F@microsoft.com...
>> >I am using a memo field in a VFP8 dbf to hold a bmp file.  All is well 
>> >till
>> >I
>> > try to access the dbf using sqlselect & odbc.  The corresponding field
>> > within
>> > the resulting cursor is a 'General' data type.
>> > 1) Any way to get this back as a mem field?
>> > 2) If not, any way to dump the data out of the cursor into a file?
>> >
>> >
>>
>>
>> 


Relevant Pages

  • Re: General field?
    ... Sounds like you've actually stored it in a General type field, as ODBC would ... >I am using a memo field in a VFP8 dbf to hold a bmp file. ... > the resulting cursor is a 'General' data type. ...
    (microsoft.public.fox.programmer.exchange)
  • Exporting Access report to Word
    ... I export data to word using DDE or ODBC. ... amounts of data (i.e. memo field). ... However if you concatenate two memo fields in the query ...
    (microsoft.public.access.externaldata)
  • Re: Merge a letter to Access
    ... > The solution seems to be the ODBC. ... and the memo field the info is being ... So I opened an old backup version of the letter, saved via DDE ... This reply is posted in the Newsgroup; please post any follow question or reply ...
    (microsoft.public.word.mailmerge.fields)
  • foxpro memo field in mail merge truncated
    ... The memo field variables truncates data. ... have updated the odbc for vfp, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Reading mm datasource
    ... I would much rather get it working with dbf, ... do with simultaneous use of the driver by more than one program. ... and looking for that specific name in the ODBC ... I tried opening Word in it's own window and setting the datasource ...
    (microsoft.public.word.mailmerge.fields)