> >>I'm having serious problems with DBC integrity. (example: Some of my
> >>clients reports transaction that complete o.k. with new records lost in
> >>some tables. Such tables doesn't accept new recods untill I validate the
> >>DBC or reindex the table, but VFP report no error )
>
> The tables with the problem, doesn't have any primary or candidate index
> and doesn't have record buffering enable.
> I'm sure the tables or the indexes were corrupted because I tried from the
> command windows with append from
, VFP reports no error but
> no records were appended.
Then I would:
COPY STRU TO [NewTable]
USE [NewTable]
APPEND FROM [OldTable]
USE [OldTable]
ZAP
APPEND FROM [NewTable]
Hopefully this won't violate too many table constraints {g}
/Paul