Hi,
Does anyone knows how to export MEMO field type to a text file?
And then, how to organize it so it can be imported from another database?

Thanx
Eduardo

You'll have to come up with you're own set of rules. My favorites are
CSV w/ everything quoted and w/ a literal character '^' and pipe
separated w/a literal.

So a single record in CSV would look like:

"Field 1","121.111","Memo line 1
memo Line 2
Memo line 3 with a ^"Quoted Value^"
Memo line 4", "Field 4"

If you want to import these, I add control records & use the first 2
fields for commands:

"$Table","MyTable"
"$Fields","MyTable","Field 1","Field 2","Memo Field 3","Field 4"
"$Insert","MyTable","Field 1","121.111","Memo line 1
memo Line 2
Memo line 3 with a ^"Quoted Value^"
Memo line 4", "Field 4"

This way you can store an entire database in a single text file. For
BLOBs, you can use hex encoding.

HTH,

Sean



Eduardo wrote:
> Hi,
> Does anyone knows how to export MEMO field type to a text file?
> And then, how to organize it so it can be imported from another database?
>
> Thanx
> Eduardo
>
>

You might want to look at SMI/SME as it allows you to import/export
from dataset to dataset. (field mapping)
http://www.scalabium.com

Also, if you need to export, I have better luck exporting to XML especially
if the memo/blob has special chars.
SMI/SME has XML

Another to look at is:
http://www.deepsoftware.com/rsllib/

Regards,
Scott.

"Eduardo" <eduardo@brscan.com.br> wrote in message
news:CE764653-463C-4D82-A5F1-A9C7255FDD65@news.elevatesoft.com...
> Hi,
> Does anyone knows how to export MEMO field type to a text file?
> And then, how to organize it so it can be imported from another database?
>
> Thanx
> Eduardo
>
>

Eduardo,

<< Does anyone knows how to export MEMO field type to a text file? And then,
how to organize it so it can be imported from another database? >>

You cannot export memo fields to text files in DBISAM due to the CRLF issues
that exist.

--
Tim Young
Elevate Software
www.elevatesoft.com