Hello Ivan.<br><br>The procedure is partly wrong. You have to:<br>a) create a TEXT field (I don't know if the problem goes for VarChar too), <br>b) type the 3 lines of text and <br>c) OPEN the db from a Director11 movie, <br>
d) RETRIEVE the f2 field and <br>e) put it in a TEXT member. <br>Then you will see that there are blank lines inserted for every paragraph change (RETURN character). Please reproduce and let me know if you see the problem.<br>
<br><br><div class="gmail_quote">2010/1/22 Ivan Smahin <span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com">ivan_smahin@paradigmasoft.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hello Panagiotis,<br>
<div><div></div><div class="h5"><br>
Friday, January 15, 2010, 1:59:18 PM, you wrote:<br>
<br>
> Hello there.<br>
<br>
> I am using Valentina for Director 11 (PC) and I noticed that when<br>
> importing text from a Text or VarChar field, Valentina inserts a<br>
> blank line for every RETURN (paragraph change) there is in the text.<br>
> This happens both if storing plain text or storing the RTF encoding<br>
> (which I translate to formatted text with the member(x).rtf command<br>
> within Director) in VStudio. The problem does NOT happen if I import<br>
> the text (either txt or rtf) from a text file on my disk drive,<br>
> using the import button or importFileInto command of Director.<br>
<br>
> Could you please let me know why this may happen?<br>
<br>
> Regards,<br>
> Takis<br>
<br>
</div></div>I'm trying to reproduce it and found nothing for now...<br>
<br>
So I do following:<br>
Run vStudio and create a new db.<br>
Then,<br>
<br>
CREATE TABLE t1 ( f1 long, f2 VarChar(128) );<br>
<br>
Then I add a single record and fill f2 with such text:<br>
<br>
Test1<br>
Test2<br>
Test3<br>
<br>
<br>
Then do export to the file - it looks like this:<br>
<br>
1 "Test1<br>
Test2<br>
Test3<br>
"<br>
<br>
After that - create another table for import:<br>
<br>
CREATE TABLE t2 ( f1 long, f2 VarChar(128) );<br>
<br>
And do import from file.<br>
t2 looks like t1 now -<br>
<br>
Test1<br>
Test2<br>
Test3<br>
<br>
in f2 field.<br>
<font color="#888888"><br>
--<br>
Best regards,<br>
Ivan Smahin<br>
Senior Software Engineer<br>
Paradigma Software, Inc<br>
Valentina - The Ultra-Fast Database<br>
<a href="http://www.valentina-db.com" target="_blank">http://www.valentina-db.com</a><br>
</font><div><div></div><div class="h5"><br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></div></blockquote></div><br>