First problem: When attempting to update a record from one table-based form I get an error: "FS215 - The quickdex or rightdex index has been corrupted. You can rebuild the index by executing a List or Select command." I'm not sure how it wants me to issue those commands but I tried to manually rebuild my indexes but this results in:

Second Problem: I've tried to manually rebuild my indexes. For several of my indexes I get the error: "ENG0010 - F.Distributor line 3. Variable has not been assigned a value." At this point my whole computer dies and I must re-boot.

Needless to say, this is very worrisome behaviour from a database. Once again any ideas or help would be most appreciated.

Greg,

A QuickDex is not a 'real' index in the same way as a BTree/XRef etc. To rebuild it I would go to the table in question and delete the %RECORDS% record. Then do an RList "SELECT" on the table, and this should rebuild it.

Then see if this helps with your second problem

cpates@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

Be aware though that quickdexes have a 64K key limit (which I have exceeded on a number of occasions

Regards

Thanks for the speedy repsonse. Can you tell me where the %RECORDS% exists? I hope I don't access it through the Table Browser because this crashes each time I try to look at my table. I'm new to this and I can't seem to find any info on %RECORDS% in the "Native Tables" manual. Maybe someone can tell me what a rightdex or quickdex is as well. I only have xref, btree and relational indicies defined. Thanks.

Greg,

%RECORDS% is located in the actual data table itself. To delete it easily just enter the following in the System Editor's Exec line:

RUN DELETE_ROW TABLE_NAME "%RECORDS%"

dbakke@srpcs.com

SRP Computer Solutions

It says the row does not exist when I try and delete it.

RUN DELETE_ROW "PERSON", "%RECORDS%"

FS100: Record "%RECORDS%" does not exist.

SSP612: Unable to delete row(s) "%RECORDS%"; 0 row(s) deleted.

View this thread on the forum...