<<>>

>>What does blanking the record in a table that has unique indexes do? Part of what prompted my "crap" outburst is that I want to add unique indexes to our production tables. This would enforce uniqueness. But none of our updating code reuseses deleted records. We have many duplicate records in our tables (one deleted, one not deleted). In code we totally ignore deleted records. It would be an impossible task for me to rewrite all the undate code, so it is impossible for me to add unique indexes to our tables.
>>
>>Brenda

>I thought unique indexes were something to be avoided at all costs...

>-Michelle

Like I said, VFP is a different world. Reread the pages in the Developers Guide - "The table indexed by a unique index could contain duplicate values." Seems that having a unique index does not enforce uniqueness. Duplicate records will not create a new entry in the index, but will get inserted into the table.VFP is a Different World.

Now I wonder what was up with my parameterized view that I wanted to use for an updatable grid's recordsource. Do you ever use them? wOw

Brenda