Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Simple Foxpro extract of client\t data using old SQL, Memo field issues

Simple Foxpro extract of client\t data using old SQL, Memo field issues

Simple Foxpro extract of client\t data using old SQL, Memo field issues

I am simply trying to extract an very old foxpro database for migrating to new reservations system. I brushed up on my SQL & FOX pro (been about 25 years) but having issues with collecting the data from 2 MEMO fields.

The simple SELECT * from database name INTO DBF newfile. Got everything EXCEPT the two MEMO fields stored in a .FPT file. So have tried about everything to resolve and checked hundreds of forums. It did extract but into .DBF and a .FPT files.

I switched to listing field names so I could select specifically the MEMO fields and just collect the first 200 or so characters of each. I have tried LEFT(CL_EMAIL,255) with the AS CL_EMAIL and without the AS,. I have tried CAST, I have tried SUBSTR all to no avail. Lots of forums complaining about having MEMO fields truncated to 255 chars. I would be fine with that.

When I use INTO DBF, it puts the memo fields into 2x extracted .DBF & .FPT files (which is where they are stored now). I am trying to merge into 1 file. Could be several different file formats for the extract. They can work with that.

So SELECT INTO nnnn.TXT also has not worked. I only get the first one character of the CL_EMAIL memo field. When I tried SUBSTR in one attempt it gave the email as 180. maybe the largest field size of the CL_EMAIL in the .FPT file?

The ancient software program will allow an extract for mailing labels including a disk extract with the CL_EMAIL field but I want phone numbers and lots of other fields.

Too many late nights. Need assistance!! (not too technical please. 68 yr old brain is still pretty smart but dont push it).

Lorraine Hall
Want to be retired

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close