Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

Test if table in a foxpro database is corrupted

foxpro

This topic has been archived. This means that you cannot reply to this topic.
4 replies to this topic

#1 sanchomosso

sanchomosso

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 07 June 2015 - 09:22 AM

1. How do i check to see if a table in a foxpro database is corrupted? 

2. What is the best way to this test?
 

I want to do this check before retrieval of data

I await a response.
Thanks in advance.



#2 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts

Posted 08 June 2015 - 04:00 AM

Attempt to open it in Foxpro.


Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#3 PBJ

PBJ

    CC Addict

  • Advanced Member
  • PipPipPipPipPip
  • 176 posts

Posted 08 June 2015 - 01:55 PM

FoxPro, are you serious? Please tell me this is a joke.



#4 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts

Posted 09 June 2015 - 03:59 AM

PBJ, you'd be shocked at how often I have to migrate data out of a FoxPro database for my job. A couple years ago, I encountered a database system that had to be run in a virtual machine because there was only a 16-bit engine for it!


Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/


#5 kasperwolter

kasperwolter

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 16 June 2015 - 09:05 AM

Perform these actions to resolve this issue

You need to create an environment under which the table is NOT validated when it is opened. This can be achieved by the command -SET TABLEVALIDATE TO 0. Now you can easily open your tables.

These are some “Prevention Steps” to prevent your data from corruption:

Try to put a code in your program that automatically creates a duplicate copy of your tables (columns & rows), index files and databases.
Set-up a back-up routine.
Inform the user to properly shutdown the computer and regularly perform back-up.
Use UPS for power back-up


Edited by WingedPanther73, 16 June 2015 - 11:05 AM.
Remove spammy link