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

Advanced
-Collapse +Expand V.FoxPro Store

Prestwood eMagazine

May 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  
David.M2
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 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=3703
Location=Wilmington, NC USA 
Joined=7 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

Fred Stevens
VFP Programmer Analyst
Prestwood Software
http://www.prestwood.com

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


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