Nice try ;-)

>>I expected it to be " where &tcKeyFld not in (select distinct &tcKeyFld ...).


Unfortunately the use of expr is correct. The problem is that I need find records where the content has changed. The view does not, and can not, construct the keys before this routine as the existing records must keep the same key. If the key was somehow constructed from the contents then this method would be fine and probably very fast.

The GetFldExpr returns a field list that can be brought into one string for comparison. Heres an example:

padl( VALVEGROUP, 10 ) + padl( SIZEINC, 10 ) + padl( PORTS, 1 ) + SERIES + SIZE + PLUGDESIGN + LEAKAGE + SEAT + SEAT_CHAR + padl( SEATMAT_ID, 2 ) + PRATING + padl( PMA, 5 ) + padl( TMA, 5 ) + padl( TMO, 5 ) + padl( PMO, 5 ) + STEM_SEAL + STEM_CHAR + padl( PRODGPID, 10 ) + padl( RNGABLTY, 7 ) + padl( BODMATID, 2 ) + padl( CVALVE_MAT, 1 ) + UNIT_ID + padl( FAMILY_ID, 10 ) + padl( SGID, 10 )

For each row, something like the following will be returned:

1.00 5 12KDN15 Caged parabolic0.01% of Kvs Hard faced W17PN40 40.0300.0300.0 40.0Bellows sealed B 0 50.00 44 0 0

It is then possible to find what is one table and not the other using the select not in approach.

Hold on. Just had bright idea!!!!

index on expr tag expr and the use your seek method. Time to play ;-)

I'll let you know


Jason