You have set deleted on, I believe, and/or indexseek does not see deleted records for index with filter.
>I keep getting a uniqueness violation error in the following code after the insert.
>
Select tparams
> Local lcSetFeature
> lcSetFeature=lcToolSet+'.'+Alltrim(cImport.ffeature)
> If !Indexseek(lcSetFeature,.F.,'tparams','setfeature')
> **fgagenum is not included in the import data
> Insert Into tparams (ftoolset,ffeature,fbase,fplus,fminus) Values ;
> (lcToolSet,cImport.ffeature,cImport.fbase_b,cImport.fplus,cImport.fminus)
> Endif
>
>
>Where setfeature is a primary key.=alltrim(ftoolset)+'.'+alltrim(ffeature) filter set to .not. deleted().
>
>First I am searching to see if the key already exists with the indexseek. Then if it does not, I insert a new one. How is uniqueness being violated. I have set exact on.