>>
>>I'm sorry but you've lost me on this one "Instead a seek from view to table could benefit existing table "expr" tag."
>
>

---

Ohh sorry. Table probably already has an index with key expression what GetExpr() returns. It's static and existing, but view has no index set. For inserting new recs a scan on view :
>

select (tcView) && Addition part
>scan for !seek(eval(GetExpr()),tcTable, "ExprTag")
>    insert into ....
>endscan
>
>select (tcTable) && Deletion
>lcExpr = getexpr()
>scan
> lcVal = eval(lcExpr)
> select (tcView)
> locate for &lcExpr = lcVal
> llNotFound = eof()
> select (tcTable)
> if llNotFound
>   delete
> endif
>endscan
>
>* Or this could be faster for deletion ?
>delete from (tcTable) ;
> where &lcExpr not in (select distinct &lcExpr from (tcView))

Not trying to index on view might recover time by letting Rushmore do it as necessary.
>Cetin

Wow - scan through 1 million records and perform a locate on a view that contains 1 million records with no index!! Interesting concept, but I think I'll give that one a miss :o)

Didn't know you could use sql delete like that... Looks promising.

I see you've been putting a lot of brain power into this one. It must be a real challenge ;o)

I really appreciate you assistance with this one

Jason