Database becoming corrupted on client computer

[Trevor DeVore]

Hi,

In the last several weeks I have received reports from two customers 
about a problem with some of our software and I am stumped as to what 
is causing it.  The problem only occurs on a screen that accesses the 
"People" portion of our valentina database (We are using the XCMD with 
Revolution and the clients are running XP).  Our software only reads 
from the database in the software, no writes at all.  Both clients are 
running Windows XP on P4 with > 3 GHZ processors.  One computer has 2 
GB of RAM, the other has 4GB of RAM.  One is a Dell, the other is 
AlienWare area-51.

I had one of the clients send me his database and a diagnose shows that 
the "People" table is becoming corrupted on his computer.  Below I've 
included a diagnose from the db we shipped with the product followed by 
a diagnose of the table form the db the customer sent me.  I also 
included an XML description of the table.

The Biography field is saying that it has orphan segments.  I remember 
running into this problem during development if I indexed a field by 
words but didn't check the index box in the Valentina Carbon app.

Does anybody have any idea what might be causing such a problem?  I'm 
wondering if perhaps the >= 2GB of RAM might be the culprit since we 
have few if any customers that would have that much RAM installed.  It 
is the only thing that really sticks out.

Thanks for any insight anyone has.

-- 
Trevor DeVore
Blue Mango Multimedia
trevor at mangomultimedia.com




===============================
==========  ORIGINAL DIAGNOSE OF DATABASE ============
===============================

************************************************************************
* BaseObject: "People"
************************************************************************
All right.

-----> Field: "SectionAssociations' of type Text
All right.

-----> Field: "FirstName' of type VarChar
All right.

-----> Field: "Biography' of type Text
All right.

-----> Field: "Birth' of type VarChar
All right.

-----> Field: "Death' of type VarChar
All right.

-----> Field: "Notes' of type Text
All right.

-----> Field: "LastName' of type VarChar
All right.

-----> Field: "ID' of type ULong
All right.

===============================
==========  DIAGNOSE OF DATABASE FROM CLIENTS COMPUTER ============
===============================

************************************************************************
* BaseObject: "People"
************************************************************************
Problems found.

-----> Field: "SectionAssociations' of type Text
All right.

-----> Field: "FirstName' of type VarChar
All right.

-----> Field: "Biography' of type Text
Problems found!

(!) Minor problem: exists 17 orphan segments.(indicate mistake in 
algorithm.)


-----> Field: "Birth' of type VarChar
All right.

-----> Field: "Death' of type VarChar
All right.

-----> Field: "Notes' of type Text
All right.

-----> Field: "LastName' of type VarChar
All right.

-----> Field: "ID' of type ULong
All right.


===============================
========== XML DESCRIPTION OF TABLE ============
===============================

<BaseObjectDesc Name="People">
	<FieldCount>8</FieldCount>
	<FieldDesc Name="SectionAssociations">
		<Type>Text</Type>
		<Indexed>0</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
		<Language>ASCII</Language>
		<SegmentSize>1024</SegmentSize>
	</FieldDesc>
	<FieldDesc Name="FirstName">
		<Type>VarChar</Type>
		<Indexed>1</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
		<MaxLength>256</MaxLength>
		<Language>ASCII</Language>
	</FieldDesc>
	<FieldDesc Name="Biography">
		<Type>Text</Type>
		<Indexed>1</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>1</IndexByWords>
		<Compressed>0</Compressed>
		<Language>ASCII</Language>
		<SegmentSize>1024</SegmentSize>
	</FieldDesc>
	<FieldDesc Name="Birth">
		<Type>VarChar</Type>
		<Indexed>0</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
		<MaxLength>256</MaxLength>
		<Language>ASCII</Language>
	</FieldDesc>
	<FieldDesc Name="Death">
		<Type>VarChar</Type>
		<Indexed>0</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
		<MaxLength>256</MaxLength>
		<Language>ASCII</Language>
	</FieldDesc>
	<FieldDesc Name="Notes">
		<Type>Text</Type>
		<Indexed>1</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>1</IndexByWords>
		<Compressed>0</Compressed>
		<Language>ASCII</Language>
		<SegmentSize>1024</SegmentSize>
	</FieldDesc>
	<FieldDesc Name="LastName">
		<Type>VarChar</Type>
		<Indexed>1</Indexed>
		<Unique>0</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
		<MaxLength>256</MaxLength>
		<Language>ASCII</Language>
	</FieldDesc>
	<FieldDesc Name="ID">
		<Type>ULong</Type>
		<Indexed>1</Indexed>
		<Unique>1</Unique>
		<Nullable>0</Nullable>
		<IndexByWords>0</IndexByWords>
		<Compressed>0</Compressed>
	</FieldDesc>
</BaseObjectDesc>