Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: James Doherty
  Where is James Doherty?
 Dublin
 Ireland
 James Doherty
 Tags
Subject: SEEK() appears to hang
Thread ID: 228683 Message ID: 228683 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Errors & Debugging
Date: Wednesday, May 20, 2009 7:43:49 PM         
   


Hi All,

This one is completely baffling me at this stage having spent much time debugging the code to track down the issue.

What is happening is that within a conditional SCAN...ENDSCAN and with NEAR & EXACT set to "ON" there is a SEEK() being performed on a small table (600-ish records) for a value. The SEEK succeeds and returns true (.T.). ENDSCAN is reached and the SEEK is performed again as part of the SCAN WHILE condition. This time, despite looking for the exact same value as the previous SEEK() it appears to hang!

I have deleted the tag (index) involved and reindexed the table by adding the index manually again but this has had no effect. Does anyone have any idea why this might be happening? Hope I have provided enough informations and that what is being attempted makes some sense.

Any help would be gratefully appreciated.

Thanks J

ENTIRE THREAD

SEEK() appears to hang Posted by James Doherty @ 5/20/2009 7:43:49 PM
RE: SEEK() appears to hang Posted by Yuri Rubinov @ 5/20/2009 7:45:39 PM
RE: SEEK() appears to hang Posted by James Doherty @ 5/20/2009 7:59:49 PM
RE: SEEK() appears to hang Posted by Yuri Rubinov @ 5/20/2009 8:06:11 PM
RE: SEEK() appears to hang Posted by James Doherty @ 5/20/2009 8:42:46 PM
RE: SEEK() appears to hang Posted by tushar @ 5/20/2009 8:18:27 PM
RE: SEEK() appears to hang Posted by Yuri Rubinov @ 5/21/2009 3:58:44 PM
RE: SEEK() appears to hang Posted by James Doherty @ 5/21/2009 4:31:59 PM
RE: SEEK() appears to hang Posted by Tamar Granor @ 5/21/2009 10:26:38 PM
RE: SEEK() appears to hang Posted by James Doherty @ 5/22/2009 10:10:10 AM