ODBS Foxpro connection error

[Dave Fisher]

I'm attmpting to link a Foxpro table to access 97 using
ODBC but am getting the following message "Invalid
field 'DELETED'() in definition of index or relationship".

Has anyone any ideas as to the cause of this and possible
solution.

 

[Cindy Winegarden]

In [email protected],

I'm attmpting to link a Foxpro table to access 97 using
ODBC but am getting the following message "Invalid
field 'DELETED'() in definition of index or relationship".

Hi Dave,

In FoxPro tables, deleting a record does not actually remove it from the
table but rather marks it as deleted. The record is then filtered out using
SET DELETED ON. The DELETED() function you are seeing is used to determine
whether a record is deleted or not. Many times developers use "SomeField
WHERE NOT DELETED()" as an index expression to prevent duplicate key values
when entering a key that was previously deleted.

It's hard to know exactly what's happening without knowing more about the
database and its persistent relationships and also about the index keys in
use.