[RBASE-L] - Re: Foreign Key Error

[A. Razzak Memon]

At 01:28 PM 6/18/2004 -0500, Steve Fogelson wrote:

I am getting "-ERROR- A foreign key is referencing the wrong table (1240)"
when I run autochk on a db.

I have ran R:Scope 6.5 and checked Database Info, Structure and Data with no
errors

Steve,

I suggest to re-build the INDEXes (using 6.5++, Build: 1.866xRT03 or higher).

Example 01:

  PACK INDEX FOR <TableName>
  This will pack all the indices for the specified table,
  even in a Multi-User environment.

Example 02:

  PACK INDEX
  This will pack all the indices for currently CONNected
  database, even in a Multi-User environment.

Very Best R:egards,

Razzak.