Thanks Sergey,

You are just amazing. Thanks Again.

>Change connecion string BackgroundFetch=No
>See Re: Serious Bug in REQUERY() Message #815973 for details
>
>
>>
>>Kindly check this code, the records are getting duplicated.
>>

>>IF !DIRECTORY( 'C:\DELME')
>>   MD C:\DELME
>>ENDIF
>
>
>>CREATE TABLE C:\DELME\X1 (F01 C(5))
>>FOR lnCnt = 1 TO 10000
>>   INSERT INTO X1 (F01) VALUES (SPACE(5))
>>ENDFOR
>>REPLACE ALL F01 WITH TRANSFORM( RECNO())
>>USE IN X1
>>
>>lcCS = [Driver=Microsoft Visual Foxpro Driver;SourceDB=C:\DELME\;SourceType=DBF;Exclusive=No;
>BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;]
>>lnH = SQLSTRINGCONNECT( lcCS)
>>
>>LOCAL lcSQL
>>lcSQL = [ SELECT F01 FROM C:\X1]
>>?SQLE( lnH , lcSQL, '_cT1')
>>?SQLDISCONNECT( lnH)
>>
>>SELECT '1', CNT(*),F01 FROM _CT1 GROUP BY 3 ORDER BY 1 DESC HAVING CNT(F01)>1 INTO CURSOR _cT1X
>>BROW
>>

>>
>>After you try this code couple of time you would realize _cT1 is having duplicated records, Any ideas why this is happening.
>>This only happens when using ODBC
>>
>>Thanks