Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Handling M type in export files
Message
From
11/09/2013 22:04:00
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Handling M type in export files
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01582931
Message ID:
01582931
Views:
75
Okay, I know there is a trick to this.

I am writing a program that will iterate a VFP database and create pipe separated text files with no quotes and the data appropriate massaged for the SQL tables that will bulk upload them.

I have some memo fields.

I can do something clumsy that initailly puts a blank character in the column that will go to the SQL varchar(max) and then dummy up something to suck data in ( I do NOT want to use any kind of OLE or OLEDB to connect ot VFP if I can get around it. )

Does anybody have tricky magic??


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Next
Reply
Map
View

Click here to load this message in the networking platform