Re: validate database error

Author: Rafael Copquin

Posted: 2011-02-18 at 10:18:35

What I do is this:

set tablevalidate to 0

set exclusive on

open database........

remove table ..... the one giving you trouble

use ...... that table

append blank

go bottom

delete (the blank record)

pack

use

rebuild the indexes

add table .....

Once added, remember to change the primary key from candidate to

primary, since it will be changed automatically to candidate when you

remove the table from the database

Rafael Copquin

El 17/02/2011 13:02, James E Harvey escribió:

> While validating a database this message occurs:

>

> Validate Database HANOVER

> Rebuilding structural index.... Index rebuilt

> Object #959 (Index 'req'): Bad property types or lengths: 1

>

> I "use" the database, browse for Objectid = 959, and see the Objecttype is

> "Index" with an Objectname = req. The "Property" record shows a table

> "hftrns.dbf".

>

> Then hftrns.dbf does not have a "req" index tag.

>

> Can I remove the data in the property field and expect the Validate to be

> successful?

>

>

>

>

> James E Harvey

> Corresponding Officer/M.I.S.

> Hanover Shoe Farms, Inc.

> www.hanoverpa.com

> jharvey@hanoverpa.com

> 717-637-8931

> fax: 717-637-6766

> cell: 717-887-2565

>

>

[excessive quoting removed by server]

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/4D5E8DCB.9020800@ciudad.com.ar

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.

©2011 Rafael Copquin