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
_______________________________________________
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/021a01cbcebc$0970c4f0$1c524ed0$@hanoverpa.com
** 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.
On 2/17/2011 11:02 AM, James E Harvey wrote:
> 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?
Backup the files first. Then add the RECOVER option to that command to
see if that fixes it. Sorry, Jim, in a hurry with other stuff but
wanted to fire that off to you to try in the meanwhile.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
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/4D5D4EB5.3050102@mbsoftwaresolutions.com
** 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.
Thanks Michael, I did as you suggested, and it worked, no more error
message.
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
-----Original Message-----
From: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf
Of MB Software Solutions, LLC
Sent: Thursday, February 17, 2011 11:37 AM
To: ProFox Email List
Subject: Re: validate database error
On 2/17/2011 11:02 AM, James E Harvey wrote:
> 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?
Backup the files first. Then add the RECOVER option to that command to see
if that fixes it. Sorry, Jim, in a hurry with other stuff but wanted to
fire that off to you to try in the meanwhile.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
[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/022601cbcec1$38839ab0$a98ad010$@hanoverpa.com
** 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.
>>Thanks Michael, I did as you suggested, and it worked, no more error<<
I believe it was Doug Hennig who suggested that the RECOVER clause of the
VALIDATE DATABASE command should be renamed to HOSE.
Seriously, the RECOVER clause normally removes stuff from the DBC, so you
should check to see if you need to add a tag back to the table.
Rick
White Light Computing, Inc.
www.whitelightcomputing.com
www.swfox.net
www.rickschummer.com
_______________________________________________
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/008601cbced0$4c2a4870$e47ed950$@com
** 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.
On 2/17/2011 1:27 PM, Rick Schummer wrote:
>>> Thanks Michael, I did as you suggested, and it worked, no more error<<
>
> I believe it was Doug Hennig who suggested that the RECOVER clause of the
> VALIDATE DATABASE command should be renamed to HOSE.
>
> Seriously, the RECOVER clause normally removes stuff from the DBC, so you
> should check to see if you need to add a tag back to the table.
LOL! Well, I did advise him to make backups first!!! The best
solution, imho, is to use Doug's Stonefield Database Toolkit as that
takes care of your database image being as it should be, repairing and
rebuilding if necessary.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
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/4D5D7DFB.5060307@mbsoftwaresolutions.com
** 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.
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.
On 2/18/2011 10:18 AM, Rafael Copquin wrote:
> 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
Don't forget also that by removing it from the DBC, you'll lose long
field names, default values, validation rules, captions, and triggers on
that table.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
_______________________________________________
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/4D5E91B0.6060507@mbsoftwaresolutions.com
** 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.
I forgot one line of code:
validate database recover
Rafael Copquin
El 18/02/2011 12:18, Rafael Copquin escribió:
> 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/4D5E939C.3050908@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.