Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Index tag is not found
Message
From
22/02/2000 10:22:54
Rex Mahel
Realm Software, Llc
Ohio, United States
 
 
To
21/02/2000 10:44:53
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00333494
Message ID:
00335378
Views:
22
Doug,

I solved the problem, here' the scoop:

I had a Clinic table with a foreign key of iCityId.
I changed the structure via SDT by taking the address information to a new table Location.
SDT did not remove the foreign key relation for iCityId.
I ran the VALIDATION.PRG with no success
I finally ran VALIDATE DATA RECOVER on the DBC and the problem was solved

SDT should have removed the relation, and if it didn't the VALIDATION.PRG shoudl have fixed the problem, IMHO.

Thanks

Rex

>Hi Rex.
>
>>According to my message, I already did this and got the above message again.
>
>The only time I've seen the RI Builder give that message is when there are deleted records in the DBC. You could confirm this by opening the DBC as a table (USE DBC() AGAIN SHARED) and seeing if there are any deleted records (SET DELETED OFF, LOCATE FOR DELETED()). If you find some, then for some reason, the Cleanup Database function didn't work, so you might want to PACK DATABASE to ensure it's packed.
>
>Doug
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform