Memo Fields in FoxPro for DOS

Question:
I am working on a FoxPro for DOS system and I am using the COPY TO function to export the DBF to a (text or Microsoft Excel) file. However, the information contained in the Memo fields does not get exported. Why is this? How can I get around this?

Answer:
The help system for the COPY TO function states that Memo and General fields will not be copied even if you include their names in the field list. This is probably because most formats require fixed-length information, while memo and general fields are of variable length.

The only workaround (and it won’t be a very good one) would be to create a temporary file with a 254-character field and store the first 254 characters of the memo field. Then the COPY TO will give you the first 254 characters. You could even have a couple of 254 character fields with segments of information that can be reassembled into a memo structure wherever you are sending the exported file.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS