>Please confirm, is this VFP bug ?
>
>
>CREATE CURSOR Cursor1 ( Field1 c(10) )
>INSERT INTO Cursor1 VALUES ('HLADU' )
>INSERT INTO Cursor1 VALUES ('POOD')
>
>CREATE CURSOR RCursor ( Field1 c(10) )
>INSERT INTO RCursor VALUES ( 'HLADU' )
>INDEX ON Field1 TAG T
>
>SELECT Cursor1
>SET RELA TO Field1 INTO RCursor
>
>UPDATE Cursor1 ;
> SET Field1=Field1 ;
> WHERE !EOF('RCursor') AND ;
> Field1 IN (SELECT Field1 FROM RCursor )
>* Result: 0
>* Expected result: 1
>messagebox( STR(_TALLY) )
>I confirm _TALLY = 0 in VFP7 9262, VFP6 SP5 and VFP5 SP3. If the SET RELATION line is commented out all 3 versions yield _TALLY = 1.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up
