>>I have what is apparently an invalid database. Among the problems, some of the tables have an "Invalid primary key property." When I try to open the table, or alter it, I get an error telling me "Primary key property is invalid; please validate database." Issuing a VALIDATE DATABASE merely lists the problems, it doesn't solve them. How can I fix the primary key problem? Also, I need to be able to do it programmatically at a client's site.
>>
>>Thanks,
>
>Elyse,
>Try:
>close database
>open database mydatabase exclusive
>validate database recover
>
>For future reference look into getting Stonefield Database Toolkit for an easy interface to handle problems like this.
I have Stonefield, but it seems that even Stonefield was having trouble with this. I think the RECOVER will help, but that can't be done programmatically.
Elyse Pomerantz