Exporting Memo type fields

[tjc]

the only way to do this is by writing ObjectPAL code and using the
textStream ObjectPAL class to write the file out to disk.

--
tjc

m.fr...@mailbox.uq.oz.au (Mark French) wrote:

>Help,

>Is there anybody who knows a way to export Memo type fields into
>delimitied ascii text from Paradox tables without loss of data.

>Thanks
> Mark

[Mark French]

[Brian Ivie]

m.fr...@mailbox.uq.oz.au (Mark French) wrote:
>Is there anybody who knows a way to export Memo type fields into
>delimitied ascii text from Paradox tables without loss of data.

Try ...

var
mem Memo
endVar

mem.writeToFile("*Name of file to export to")

Hope this helps!

Brian Ivie
Brigham Young University

[Doug Kendall]

While restructuring a table (lengthening an alphanumeric
field), I get the following error message:

"Unexpected Condition. Corrupt Memo Block for
%s--Leaving Paradox"

This occurs after hitting "DO-IT!" while PARADOX is
restructuring. I get bumped out to DOS, and generally the
*.DB file has been deleted (I can get it back using the
Netware SALVAGE program), although all the supporting files
including the *.MB file are still there. I am not changing
either of the 2 memo fields in the table when this happens.

Any idea what's going on and how to avoid data loss from
the memo fields? Thanks for your thoughts.
--
Doug Kendall, Curator of Domestic Life
State Historical Society of Wisconsin, Museum Division
816 State St., Madison WI 53706; (608)-264-6552
e-mail: dken...@facstaff.wisc.edu

[Charles L. Savage]

dken...@facstaff.wisc.edu (Doug Kendall) wrote:

>While restructuring a table (lengthening an alphanumeric
>field), I get the following error message:
>
> "Unexpected Condition. Corrupt Memo Block for
>%s--Leaving Paradox"
>

(Snip)

Any time that Paradox reads the value in a memo or blob field, and the
block has corrupoted, Paradox will bail out or freeze up.

The fix is to run Tutility (DOS) or Tools/Utilities/Table repair
(Windows).

Charles Savage
MIS Director
Atkinson-Baker, Inc.
csa...@earthlink.net

[Steve Krauss]

Go to the Paradox Informant BBS and download a file called SKMEMO.zip. This is the
only one that I ran across. I uploaded it so it could help other Paradox
programmers. Not sure who wrote the code but it works!

Hope this helps.

[Frank Burleigh]

In <3tjjvi$g...@mars.earthlink.net> "Charles L. Savage" <csa...@earthlink.net> writes:

>dken...@facstaff.wisc.edu (Doug Kendall) wrote:

>>While restructuring a table (lengthening an alphanumeric
>>field), I get the following error message:
>>
>> "Unexpected Condition. Corrupt Memo Block for
>>%s--Leaving Paradox"
>>
> (Snip)

>Any time that Paradox reads the value in a memo or blob field, and the
>block has corrupoted, Paradox will bail out or freeze up.

>The fix is to run Tutility (DOS) or Tools/Utilities/Table repair
>(Windows).

I had problems like this today on a user's table; tutility did the
trick. But I'm wondering just what Paradox sees as "corrupt" and what
data loss can occur? The question comes to "what is a block and how
big is a block?"
--
Frank Burleigh 812-333-7082 (home); 812-855-9170 (work)
School of Law, Indiana University, Bloomington, IN 47405
Internet burl...@bronze.ucs.indiana.edu; CIS 72730,1017