Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Validate database
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00909036
Message ID:
00909069
Views:
16
>I'm getting three error messages when I run the "Validate Database" command.
>
>(1)Object #697 (Index "junk"): Tag not found in structural CDX for table 'health.dbf'
>
>(2)Object #137 (Table "hftrns"): One or more structural indexes missing from DBC.
>
>(3)Object #270 (Index "typeloc"): Tag not found in structural CDX for table 'master.dbf'
>
>
>1. junk shows in the project manager but is no longer an index tag.
>2. I added a new index tag "hfstsgan" = str(stateno) + str(seqno) + acct_no, but it isn't included under the table in the project manager.
>3. same as 1.
>
>Looks like I need to remove two indexes which no longer exit and add one that does.
>
>I've tried reindexing to no avail, any thoughts would be appreciated, thanks.
>
>Jim

okay, so the "Hacker's" guide says to open the dbc exclusive and then validate with the "recover" option.

This gives you the opportunity to hopefully "fix" any problems that might have cropped up.

If that doesn't work you can try to hack the dbc, or get a third party repair tool.

Why does the dbc get "messed up" in the first place? I don't ordinarily open the dbc explicitly (ie; use hanover!hftrns) when I open a table to add/edit/delete a index, is that an issue???
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform