Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: James Doherty
  Where is James Doherty?
 Dublin
 Ireland
 James Doherty
 Tags
Subject: RE: SEEK() appears to hang
Thread ID: 228683 Message ID: 228782 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Errors & Debugging
Date: Thursday, May 21, 2009 3:58:44 PM         
   


> Hi there,
>
> An update on the code here, I changed the code to from below to the following:
>
> ...
>
> SELECT shorttable
> SET ORDER TO longform
>
> FOR lnCount = 1 TO GETWORDCOUNT(tcExpression)
> lcString = GETWORDNUM(tcExpression, lnCount)
> IF SEEK(lcString)
> lcReturn = lcReturn + " " + shortform
> ELSE
> lcReturn = lcReturn + " " + lcString
> ENDIF
> ENDFOR
>
> ...
>
> And the "hang" now seems to happen at the "SELECT shortable" line! Things just got weirder!
>

How many records are there in shortable? Do you have deleted records there?
If you process with code below, will it hang?

set dele off
SELECT shortable
set dele on


Other than that, did you try to reindex?


Best Wishes,

Yuri Rubinov

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