From: contact@harganonline.com   
      
   Let's see if I get this right. You want to check each record in tc2's table   
   that has a "desc" of "W", and see if there is a record in tc1's table with   
   the same "num" and a "desc" of "W1". If, and only if, you find the tc1   
   record, you do something. Right? Then you are on the right track.   
      
   Perhaps,   
      scan tc2 for tc2."desc" = "W": ;possibly faster   
         if tc1.locate("num",tc2."num","desc","W1") then   
            ;do something   
         endif   
      endscan   
      
   If tc1's table is indexed on "num" and "desc", and the index is named (say)   
   "byNumAndDesc", this would execute much faster:   
      tc1.switchIndex("byNumAndDesc")   
      scan tc2 for tc2."desc" = "W":   
         if tc1.qlocate(tc2."num","W1") then ;uses the index   
            ;do something   
         endif   
      endscan   
      
   --   
   Jim Hargan   
      
   On Wed, 13 Aug 2008 13:28:10 -0400, Kenneth wrote:   
   > Hi Jim,   
   >   
   > Many thanks for the speedy and very helpful response...   
   >   
   > But I am still not sure I correctly understanding how I   
   > should set things up to do stuff only if something is found   
   > in the first table, but not in the second.   
   >   
   > Should that look something like this:   
   >   
   > scan tc2:   
   > 	If tc2."num" = ident and tc2."desc" = "W" and   
   > 		not tc1.locate("num",ident,"desc",W1)   
   > 	then   
   >   
   > 	do something   
   >   
   > All the best,   
      
   > On Wed, 13 Aug 2008 13:12:21 -0400, Jim Hargan   
   >  wrote:   
   >   
   >>In this line:   
   >>   if (tc2.locate ("num", ident, "desc", "W") ...   
   >>the locate() moves your tCursor within the scan. The next time the scan   
   >>loops, it will take over from this new position. And this new position is   
   >>always the same position, as locate() always sends the tCursor to the first   
   >>matching record. So your scan gets stuck on one record.   
   >>   
   >>Never move either the scanning tCursor or any records within a scan loop.   
   >>   
   >>The scan should be sending tc2 straight to the correct records, as with:   
   >>   scan tc2 for tc2."num" = ident and tc2."desc" = "W":   
   >>      ;do something   
   >>   endscan   
   >>or else testing withing the scan, as with:   
   >>   scan tc2:   
   >>      if tc2."num" = ident and tc2."desc" = "W"   
   >>         then ;do something   
   >>         else loop   
   >>      endif   
   >>   endscan   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)