I.T. Discussion Community!
-Collapse +Expand
Search V.FoxPro Group:

-Collapse +Expand V.FoxPro Store

Prestwood eMagazine

March Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyVisual FoxPro BoardMicrosoft Visual FoxPro (VFP) Topic   Print This     

FoxPro Tables

FoxPro Tables in Microsoft Visual FoxPro (VFP) topic (part of our Visual FoxPro group).

Quick Search: FoxPro Tables  
Michael Matters, Inc
Wilmington, NC USA
Rank: Cadet 3rd Year

I am looking for some help to convert MySql tables into FoxPro. In particular a large memo field in the last column continues to word wrap into the next row.  Would like to strip returns, ^l, , " etc before creating table.

 Posted 7 years ago (Thread Starter)
Comment Quote
About David.M2 -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #14904, 1 reply
Thread Started 9/14/2012 9:15:43 AM
View Counter=3610
Location=Wilmington, NC USA 
Joined=7 years ago   MB Posts=1  
Most Recent Post
Fred Stevens
Prestwood IT
Citrus Heights, CA
Rank: Lieutenant-Commander

I have not heard of this "memo field wrapping" issue before.

Foxpro has a cool function to strip text or control characters from text or memo fields [STRTRAN()] but you will need to do this process in (a copy of) the original table BEFORE converting the data to VFP, so this functionality is of no value in your situation.  I am not knowledgeable about MySQL or TSQL commands to do this.

Sorry,Big Grin!


Fred Stevens
VFP Programmer Analyst
Prestwood Software

 Posted 7 years ago
Comment Quote
About Fred Stevens -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Fred Stevens
Senior Software Engineer with Prestwood Software -- Visual FoxPro, Visual Basic.NET developer

Post ID #14905 (Level 2) and Parent is 14904
Reply Posted 9/14/2012 11:35:52 AM
Location=Citrus Heights, CA  
Joined=16 years ago   MB Posts=5   KB Posts=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1252A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14904 Counter
Since 9/14/2012
   Contact Us!
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,202 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...

©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech