V4MD 1.10

[Roland Hildebrandt]

Hi Ruslan !

It seems the problem depends of the type of field :

Long : (!) Table has X physical records but field has 256
Byte :  (!) Table has X physical records but field has 1024
Datetime:  (!) Table has X physical records but field has 128
String :  (!) Table has X physical records but field has (depend of string
length)
Float :  (!) Table has X physical records but field has 256

Where X is the number of records created in the table.

Varchar fields never has this problem.
I think it will work all right for boolean fields but I haven't tested it.

It seems this is linked with the segment size ??? In fact we use a quite
small segment size : 1024 when creating our bases because we need them to
use few disk space and we have a lot (often more than 50) of fields in each
table.

Thank a lot for all your answers !!!

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:26 AM
Subject: Re: V4MD 1.10


> on 1/27/04 11:15 AM, Roland Hildebrandt at r.hildebrandt at sbt.fr wrote:
>
> > Problem 3 :
> >
> > When creating a database and inserting data, we quickly get this message
for a
> > lot of fields when we make a database diagnose :
> >
> > (!) Table has 6 physical records but field has 256
> >
> > This creates no problems when using the database but we don't understand
this
> > message.
>
> IF this is a Boolean field, then Diagnose is WRONG.
>
> > It make it also more difficult to detect if the database is corrupted
because
> > there are always problems found when we call Database diagnose.
>
>
> -- 
> 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