V4MD: Insertion of a blank line while importing text

Ivan Smahin ivan_smahin at paradigmasoft.com
Fri Jan 22 06:42:02 CST 2010


Hello Ivan,

Friday, January 22, 2010, 2:20:51 PM, you wrote:

> Hello Panagiotis,

> Friday, January 15, 2010, 1:59:18 PM, you wrote:

>> Hello there.

>> I am using Valentina for Director 11 (PC) and I noticed that when
>> importing text from a Text or VarChar field, Valentina inserts a
>> blank line for every RETURN (paragraph change) there is in the text.
>> This happens both if storing plain text or storing the RTF encoding
>> (which I translate to formatted text with the member(x).rtf command
>> within Director) in VStudio. The problem does NOT happen if I import
>> the text (either txt or rtf) from a text file on my disk drive,
>> using the import button or importFileInto command of Director.

>> Could you please let me know why this may happen?

>> Regards,
>> Takis

> I'm trying to reproduce it and found nothing for now...

> So I do following:
> Run vStudio and create a new db.
> Then,

> CREATE TABLE t1 ( f1 long, f2 VarChar(128) );

> Then I add a single record and fill f2 with such text:

> Test1
> Test2
> Test3


> Then do export to the file - it looks like this:

> 1       "Test1
> Test2
> Test3
> "

> After that - create another table for import:

> CREATE TABLE t2 ( f1 long, f2 VarChar(128) );

> And do import from file.
> t2 looks like t1 now -

> Test1
> Test2
> Test3

> in f2 field.

Sorry - I thought it is related to import/export file feature.


-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com



More information about the Valentina mailing list