[V4RB] Updating index of newly imported records seems to fail for me

[Richard Altenburg]

On 05-06-2004 12:44, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

>> All SQL operations before the ImportText work OK (like deleting the old
>> records), but every SQL operation after the ImportText fails.
>> 
>> Seems like a bug alright...
> 
> After Inserting all. Did you Try
> 
> REINDEX DATABASE

Thanks for this idea, I tested your suggestion, earlier I tested REINDEX
TABLE Newsgroup, and I also just tested REINDEX FIELD Newsgroup.ServerURL
and REINDEX FIELD Newsgroup.GroupName.

All is not helping.

Now I did something else too: instead of trying to fix it myself, I used the
DIAGNOSE DATABASE command, and I got something weird:

Problems 
found!

********************************************************************
****
* BaseObject: 
"sysItemDescription"
*******************************************************
*****************
All right.

-----> Field: "Kind' of type Long
All
right.

-----> Field: "ParentPtr' of type ObjectPtr
All right.

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

-----> Field: "ColumnType'
of type Byte
All 
right.



******************************************************************
******
* BaseObject:
"sysItem"
******************************************************************
******
Problems found.

-----> Field: "ItemDescrPtr' of type
ObjectPtr
Problems found!

(!) Table has 42 physical records but field has
256


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

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

-----> Field: "ParentPtr' of type
ObjectPtr
Problems found!

(!) Table has 42 physical records but field has
256




********************************************************************
****
* BaseObject: 
"Newsgroup"
****************************************************************
********
All right.

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

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