PrestwoodBoards: Fred Stevens

Prestwood IT, Fred Stevens

snevets

Profile◄╣

Member Info

Member Narration

POSTS:

MB Posts (5)

KB Posts (4)

KBPOSTSBYTYPE:

Tech Articles

Account . . .

Fred Stevens

Prestwood IT

Citrus Heights, CA

Real Name:

Fred Stevens

Primary Role:

Coder

Title:

Senior Software Engineer

Company:

Prestwood IT Solutions

Website:

www.prestwood.com

Joined:

Oct 2003 (18 years ago)

Visits:

Message Boards Activity

5 posts.

More...

Thread 5 of 5

Thread Starter or a Reply (but not last)

Group

David.M2

FoxPro Tables

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 to MB Topic: Microsoft Visual FoxPro (VFP) « V.FoxPro Board

9 years ago

snevets

RE: FoxPro Tables

{Too Long!}

9 years ago

No activity last 2 weeks. Post a reply to make active.

4098
Hits

Visual FoxPro

Thread 4 of 5

Thread Starter or a Reply (but not last)

Group

Fred Stevens

RE: FoxPro Tables

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

Posted to MB Topic: Microsoft Visual FoxPro (VFP) « V.FoxPro Board

9 years ago

Visual FoxPro

Thread 3 of 5

Thread Starter or a Reply (but not last)

Group

Fred Stevens

Re: Similarities to Paradox

{Too Long!}

Posted to MB Topic: Microsoft Visual FoxPro (VFP) « V.FoxPro Board

15 years ago

2
Hits

Visual FoxPro

More...

Knowledge Base Posts

	KB Article
Fred Stevens	1. Win-32 API: Determining the Unique Network Interface Card (NIC) ID Description of technique and sample code for using VFP to access the Win-32 API and return the MAC address of the Network Interface Card (NIC. Posted to KB Topic: Visual FoxPro (VFP) 17 years ago, and updated 12 years ago (6 Comments , last by Abigail.B )	KB Post 60238 Hits	Visual FoxPro
Fred Stevens	2. Building a DSN-less Connection: Listing available databases for a SQL Server Using VFP and the Windows API to obtain and list the available databases for a selected server. Posted to KB Topic: Visual FoxPro (VFP) 15 years ago, and updated 10 years ago (3 Comments , last by Abigail.B )	KB Post 15431 Hits	Visual FoxPro
Fred Stevens	3. Win-32 API - Listing available local and network SQL Servers Demonstrates the use of the SQLBrowseConnect() Windows API call to generate a list of SQL Servers on a user’s network using VFP Posted to KB Topic: Visual FoxPro (VFP) 16 years ago (2 Comments , last by Shannon.M )	KB Post 14598 Hits	Visual FoxPro
Fred Stevens	4. Win-32 API - Listing ODBC Data Source Names Demonstrates the use of the SQLDataSources() Windows API call to generate a list of DSNs with VFP Posted to KB Topic: Visual FoxPro (VFP) 17 years ago (3 Comments , last by Carver.L )	KB Post 20641 Hits	Visual FoxPro