Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dbc internal consistency error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00904492
Message ID:
00904547
Views:
13
>Hi Rakesh, Try This:
>1. Delete .dcx of your database
>2. USE your_data.dbc EXCLUSIVE
>3. REINDEX
>4. USE
>5. OPEN DATABASE your_data.DBC
>6. CLOSE DATA

>Vladimir Sografski
>Systems Analyst


>>i have a database with about 50 tables, i am trying to modify a field in the table, however i get a 'DBC internal consistency error' every time i do this.
>>i have already done the following
>>
>>>A) removed the table and put it back
>>>B) validated the database

    I GET THIS PROBLEM ONE TIME, TRY THIS.


  • CLOSE ALL YOUR PROJECTS IF OPEN

  • FROM COMMAND WINDOW TYPE Set EXCLU ON

  • OPEN YOUR DATA WITH EXCLU ACCESS: OPEN DATA DATA_NAME EXCLU

  • ISSUE VALI DATA

  • CHECK FOR TABLE NAME THAT HAVE MISSING FIELD/NOT MATCH ON YOUR DBC

  • IF YOU FIND THE TABLE REMOVE FROM YOUR DBC

  • VALIDATE YOUR DATA AGAIN

  • DELETE THE REMOVED TABLE'S INDEXES IF HAVE

  • ADD THE NEEDED FIELDS YOU WANT TO THE REMOVED TABLE FROM YOUR DBC

  • RE-CREATE THE REMOVE TABLES INDEX

  • REINDEX THE REMOVE TABLE

  • ADD THE TABLE TO YOUR DATABASE CONTAINER AGAIN

  • VALIDATE YOUR DBC AGAIN


  • This is the process I did to my Database Container when I received the same as yours..

    I hope you can make it....
    Jojo R. dela Cuesta, B.Sc.
    eConsultant, Programmer
    Dalplus Technologies
    http://www.dalplus.com
    Previous
    Reply
    Map
    View

    Click here to load this message in the networking platform