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 DOT kherson.ua>
To: <valentina@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 DOT 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@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 DOT macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2004 Roland Hildebrandt |
