<br><br><div class="gmail_quote">2010/1/15 Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com">ruslan_zasukhin@valentina-db.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;">
On 1/15/10 1:59 PM, "Panagiotis Apostolellis" <<a href="mailto:takis73@gmail.com">takis73@gmail.com</a>> wrote:<br>
<br>
Hi Panagiotis<br>
<div class="im"><br>
> I am using Valentina for Director 11 (PC) and I noticed that when importing<br>
> text from a Text or VarChar field, Valentina inserts a blank line for every<br>
> RETURN (paragraph change) there is in the text.<br>
<br>
</div>* Importing TO or Exporting FROM<br>
<div class="im"><br></div></blockquote><div><span style="color: rgb(51, 102, 255);">I am importing from a Valentina DB into a text member of my Director movie.</span><br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im">
<br>
> This happens both if storing<br>
> plain text or storing the RTF encoding (which I translate to formatted text<br>
> with the member(x).rtf command within Director) in VStudio. The problem does<br>
> NOT happen if I import the text (either txt or rtf) from a text file on my<br>
> disk drive, using the import button or importFileInto command of Director.<br>
><br>
> Could you please let me know why this may happen?<br>
<br>
</div>Please show<br>
<br>
* few lines of your text file<br></blockquote><div><span style="color: rgb(51, 102, 255);">This is a test for Ruslan so you can see for yourself what the problem is!!!</span><br style="color: rgb(51, 102, 255);"><span style="color: rgb(51, 102, 255);">This second paragraph leaves a blank line before. The same between this and the next one.</span><br style="color: rgb(51, 102, 255);">
<span style="color: rgb(51, 102, 255);">This text was written within VStudio!</span> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
* what is produced by import OR export.<br></blockquote><div><span style="color: rgb(51, 102, 255);">Text placed in a Director text member.</span> <br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
* your code which do this import or export.<br></blockquote><div style="color: rgb(51, 102, 255);">txtWanted = "linktext, year, photo, photo_lezantes" <span style="color: rgb(255, 0, 0);">-- the fields I want to retrieve</span><br>
</div><div><span style="color: rgb(51, 102, 255);">linkTxtC = gDB.sqlSelect("SELECT "&txtWanted&" from chrono where enotita= '"&enotita&"' ORDER BY year") <span style="color: rgb(255, 0, 0);">-- get those fields from Table "chrono" matching criteria "enotita" ordered by "year"</span></span><br style="color: rgb(51, 102, 255);">
<span style="color: rgb(51, 102, 255);">gLinkTxt = linkTxtC.getRecordAsPropList(value(linCol.item[1])) <span style="color: rgb(255, 0, 0);">-- put the resulting records in a global list variable</span></span><br style="color: rgb(51, 102, 255);">
<span style="color: rgb(51, 102, 255);">txt = getProp(gLinkTxt, fText) <span style="color: rgb(255, 0, 0);">-- get field fText (in our case fText = "linktext") from within the variable</span></span> <span style="color: rgb(255, 0, 0);">gLinkTxt</span><br style="color: rgb(51, 102, 255);">
<span style="color: rgb(51, 102, 255);">pSprite.member.text = txtOrRtf <span style="color: rgb(255, 0, 0);"> -- put it as the text of a text sprite</span></span><br><br><span style="color: rgb(51, 102, 255);">The linktext field is a Text, 2044, Nullable, Indexed, UTF-16</span><span style="color: rgb(51, 102, 255);"> field</span><br>
<br></div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div class="im"><br>
<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
</div><div><div></div><div class="h5">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>