Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INDEXSEEK Bug?
Message
From
10/05/2002 07:24:35
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00654373
Message ID:
00654959
Views:
43
>Ray,
>
>I modified your code as showm below (VFP 6, SP5 and VFP 7, SP1):
>
>FOR n = 1 TO 10
> INSERT INTO anytable (pkey) VALUES (n)
> SELECT * FROM anytable && Returns an empty cursor
> IF !INDEXSEEK(n, .F., 'ANYTABLE', "PKEY")
> WAIT TRANSFORM(n) WINDOW && Now INDEXSEEK() returns .T.!
> ENDIF
>ENDFOR
>
>I'm unsure why INDEXSEEK() now returns .T. I ruled out the change in work areas caused by the SELECT statement. Selecting a table in another work area had no effect, nor did selecting the next open work area. Issuing a SELECT statement against a different table didn't have any effect either. Perhaps this may be an easier workaround than the one you have.
>
>John

Hi John,

Maybe I missed something, but I couldn't duplicate your results. The SELECT without an INTO clause pops up an empty query on each loop iteration, but the INDEXSEEK on AnyTable still returns .F.. I tried it _with_ an INTO CURSOR clause, which also changes work areas of course, but that didn't alter the results of the INDEXSEEK---still .F.. Did you do something else differently?
Ray Roper
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform