Copy To and memo fields?

Hi,

I'm running VFP 9.0, making an application which collects data from a SQL
2000 Server and synchronizes it with a Palm Pilot. I'm making the
application in the Palm with Satellite Forms and for the most part it's
working well.

However, I've just run into a road block and don't know how to solve it yet.
When I query the SQL data for one table one of the fields is a memo type
field. To sync. with the Palm I need to store the data in dbase format so I
use the Copy To... command with the type set as FOX2X. Of course the Copy
To... command doesn't copy the contents of a memo field so my application
doesn't work. Is there a work around for this? Anyone know how I can
create a dbase style table including a memo field?

Thanks in advance,
Linn

Leemi
Fri Mar 31 17:03:25 CST 2006

Hi Linn:

This is an old article, but it may still be useful:

101018 How to Copy Memo or General Fields to New Records
http://support.microsoft.com/default.aspx?scid=kb;EN-US;101018

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003

>Hi,

>I'm running VFP 9.0, making an application which collects data from a SQL
>2000 Server and synchronizes it with a Palm Pilot. I'm making the
>application in the Palm with Satellite Forms and for the most part it's
>working well.

>However, I've just run into a road block and don't know how to solve it
yet.
>When I query the SQL data for one table one of the fields is a memo type
>field. To sync. with the Palm I need to store the data in dbase format so
I
>use the Copy To... command with the type set as FOX2X. Of course the Copy
>To... command doesn't copy the contents of a memo field so my application
>doesn't work. Is there a work around for this? Anyone know how I can
>create a dbase style table including a memo field?

>Thanks in advance,
>Linn

TarekHaddad
Sat Apr 01 14:33:02 CST 2006

Hi,
Try copy it useing the type FOXPLUS. it will create a table with a memo field.

I used it to import the converted data to an ACCESS database & it is working.

Bye

"Lee Mitchell" wrote:

> Hi Linn:
>
> This is an old article, but it may still be useful:
>
> 101018 How to Copy Memo or General Fields to New Records
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;101018
>
> I hope this helps.
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> Sincerely,
> Microsoft FoxPro Technical Support
> Lee Mitchell
>
> *-- VFP9 HAS ARRIVED!! --*
> Read about all the new features of VFP9 here:
> http://msdn.microsoft.com/vfoxpro/
>
> *--Purchase VFP 9.0 here:
> http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
> 69-4500-8bf2-3f06689f4ab3&type=ovr
>
> Keep an eye on the product lifecycle for Visual FoxPro here:
> http://support.microsoft.com/gp/lifeselectindex
> - VFP5 Mainstream Support retired June 30th, 2003
> - VFP6 Mainstream Support retired Sept. 30th, 2003
>
> >Hi,
>
> >I'm running VFP 9.0, making an application which collects data from a SQL
> >2000 Server and synchronizes it with a Palm Pilot. I'm making the
> >application in the Palm with Satellite Forms and for the most part it's
> >working well.
>
> >However, I've just run into a road block and don't know how to solve it
> yet.
> >When I query the SQL data for one table one of the fields is a memo type
> >field. To sync. with the Palm I need to store the data in dbase format so
> I
> >use the Copy To... command with the type set as FOX2X. Of course the Copy
> >To... command doesn't copy the contents of a memo field so my application
> >doesn't work. Is there a work around for this? Anyone know how I can
> >create a dbase style table including a memo field?
>
> >Thanks in advance,
> >Linn
>
>

Mike
Mon Apr 03 02:41:09 CDT 2006

On Fri, 31 Mar 2006 16:30:14 -0600, "Linn Kubler"
<lkubler@chartwellwisc2.com> wrote:

>Hi,
>
>I'm running VFP 9.0, making an application which collects data from a SQL
>2000 Server and synchronizes it with a Palm Pilot. I'm making the
>application in the Palm with Satellite Forms and for the most part it's
>working well.
>
>However, I've just run into a road block and don't know how to solve it yet.
>When I query the SQL data for one table one of the fields is a memo type
>field. To sync. with the Palm I need to store the data in dbase format so I
>use the Copy To... command with the type set as FOX2X. Of course the Copy
>To... command doesn't copy the contents of a memo field so my application
>doesn't work. Is there a work around for this? Anyone know how I can
>create a dbase style table including a memo field?
>
>Thanks in advance,
>Linn
>
If you specify the field names in your Copy To ... type FOX2X it will
include the memo fields.

I have checked this in version 5.0 and 8.0, don't have 9.0 ...

Mike.

Linn
Tue Apr 04 08:08:16 CDT 2006

Yes, you are right Mike. Actually, it looks like it was working all along
but I was using Excel to read the tables which didn't show the memo field.
When I opened the tables with VFP the memo fields were there.

Problem now is that it looks like the tool I'm using to sync with the Palm
Pilot doesn't support memo fields. I'll have to try and convert them to
character fields with CAST() or something.

Thanks to all who responded,
Linn

"Mike McDowall" <m.a.mcdowall@ed.com> wrote in message
news:u8k132h0mn1iq6ni89375itjqeh20srl2j@4ax.com...
> On Fri, 31 Mar 2006 16:30:14 -0600, "Linn Kubler"
> <lkubler@chartwellwisc2.com> wrote:
>
>>Hi,
>>
>>I'm running VFP 9.0, making an application which collects data from a SQL
>>2000 Server and synchronizes it with a Palm Pilot. I'm making the
>>application in the Palm with Satellite Forms and for the most part it's
>>working well.
>>
>>However, I've just run into a road block and don't know how to solve it
>>yet.
>>When I query the SQL data for one table one of the fields is a memo type
>>field. To sync. with the Palm I need to store the data in dbase format so
>>I
>>use the Copy To... command with the type set as FOX2X. Of course the Copy
>>To... command doesn't copy the contents of a memo field so my application
>>doesn't work. Is there a work around for this? Anyone know how I can
>>create a dbase style table including a memo field?
>>
>>Thanks in advance,
>>Linn
>>
> If you specify the field names in your Copy To ... type FOX2X it will
> include the memo fields.
>
> I have checked this in version 5.0 and 8.0, don't have 9.0 ...
>
> Mike.

Mike
Wed Apr 05 02:28:24 CDT 2006

On Tue, 4 Apr 2006 08:08:16 -0500, "Linn Kubler"
<lkubler@chartwellwisc2.com> wrote:

>Yes, you are right Mike. Actually, it looks like it was working all along
>but I was using Excel to read the tables which didn't show the memo field.
>When I opened the tables with VFP the memo fields were there.
>
>Problem now is that it looks like the tool I'm using to sync with the Palm
>Pilot doesn't support memo fields. I'll have to try and convert them to
>character fields with CAST() or something.
>
Ah, yes making memo info accessible to users who don't have FP variant
is a pig. Access doesn't do it properly either.

When my users define a query including memo data, they get all the
"normal" fields in a Fox2x file, (ready for Excel, SAS or whatever).
They get another text file containing the memo data and the
identifiers.

Memo data is a pig to analyze anyway - and they get warned of this
forcefully when they ask to be able to enter memo data. At least with
a text file they can search easily on keywords. If the worst comes to
the worst they can come back to me and I'll try to convert it manually
into something more suitable. How ? Set up Y/N fields for keywords
that are of particular interest to the researchers then do searches
with $, case conversion, common spellings, unique bits of technical
terms, and Soundex(). Takes a lot of manual verification :-(

To be quite honest, I am pretty sure nobody has attempted to analyze
memo data from this system. My general feeling is that it is useless
but the users feel they should be trying to record that, but haven't
really got a clue what "that" is. I try to tell them that they should
define the answers they want and the analyses they are going to use to
get there before they add any field to their data collection
definition. Results ? Well, I _am_ talking to doctors ...

In previous projects some memo data has been "analyzed". This has
always been pretty subjective, very qualitative, and the graft has
always been given to a student as a "project". i.e. a desperate
attempt to fill their project time when nobody can be bothered to find
anything useful for them to do.

Mike.