I need a clarification on this one. I am using the CDE, and use views to update my local VFP Tables.

In the cmDataManager I have lRecycleRecords = .T.

I notice that if I delete a record (if I am using a view) and enter a new record, that deleted records are not recycled in that table. Also, I have actually set the flag in the CDE for the view to recycle deleted records, and that made no difference.

Is this the normal behavior? Is there any way to have those recycle records reused? In extremely rare circumstances I have experienced a duplicate PrimaryKey problem, and this is how I noticed this behavior (because a prior deleted PrimaryKey value had the same one as a new one being added). Also, I am allowing CodeMine to generate the PrimaryKey.

Mel Cummings