V4MD 1.10

[Roland Hildebrandt]

Hi,

Here the results of new tests :

The limit where import fails is not 511 but 509. ie (508 works, 509 fails).
It depends not of the length of the data we import. ie If you have a varchar
field more than 508 then you can't import even 10 characters.

Hope this will give any clues.

Best regards
SBT / HAPPYneuron
Roland HILDEBRANDT

----- Original Message ----- 
From: "Ruslan Zasukhin" <sunshine at public.kherson.ua>
To: <valentina at lists.macserve.net>
Sent: Tuesday, January 27, 2004 11:27 AM
Subject: Re: V4MD 1.10


> on 1/27/04 11:15 AM, Roland Hildebrandt at r.hildebrandt at sbt.fr wrote:
>
> > Problem 2 :
> >
> > When importing a lot of data we use importascii from a delimited text
file.
> > This seems to be much faster than any other method.
> >
> > Using Xtra 1.10.
> >
> > The import fails (?!) if there is a varchar field in the table more than
511
> > characters long. There is no error message and the database diagnose
displays
> > no error. In fact nothing happens, no line is added in the table. The
problem
> > appears with a crypted and a non crypted database.
> >
> > When replacing all varchars longer than 511 characters by text fields,
> > everything works fine.
> >
> >
> > Using Xtra 1.9.8
> >
> > Suprisingly everything works fine even with crypted database and long
> > varchars.
>
> Let me repeat:
>
> IF table have e.g. VarChar field with length e.g. 700 then import totally
> fails?
>
>
> -- 
> Best regards,
> Ruslan Zasukhin      [ I feel the need...the need for speed ]
> -------------------------------------------------------------
> e-mail: ruslan at paradigmasoft.com
> web: http://www.paradigmasoft.com
>
> To subscribe to the Valentina mail list go to:
> http://lists.macserve.net/mailman/listinfo/valentina
> -------------------------------------------------------------
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>