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

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 9 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=4080
Location=Wilmington, NC USA 
Joined=9 years ago   MB Posts=1  
Most Recent Post
Fred Stevens
Prestwood IT
Citrus Heights, CA

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 9 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=18 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 = P123A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #14904 Counter
Since 9/14/2012

Follow PrestwoodBoards on: 

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