Hi Mel:

lRecycleRecords (whether applied in the DM or on an individual cursor) will only work when the cmCursor object's cSource property is a native VFP table. Therefore, using a local view will not permit this behaviour.

-=Gary




>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