>I wrote a program to reindex the tables if the indicies should be corrupted.I close the databases, open the tables under fopen, delete the indicies and delete the database. I then reopen the tables ,create indicies, and recreate the database. I add the tables to the database and use the use alter table command to make the indicies that I added primary. I also set up a foreign key with the alter table command to set a relation between the two tables. Is there any way to get the program to run without asking the user if he doesn't mind deleting the databases and if he wants to rewrite the indicies that I set up as primary keys at the end. Also, is there a way to programatically set referential integrity?


I belive SET SAFETY OFF should take care of your first problem
as for RI you can use CREATE TRIGGER and DELETE TRIGGER to control this
- take a look at the code that GENDBC produces

Arnon