>>Hi,
>>
>>Can any 1 just show me what is the equivalent way of
>>

>>Select Distinct f1 from foo into cursor foo1
>>

>>
>>to do using Xbase codes ?
>>
>>TIA
>>
>>suhashegde
>
>

>CREATE CURSOR Foo1 (F1 C(10))
>INDEX ON F1 TAG Foo1
>
>SELECT Foo
>SCAN
>   SELECT Foo1
>   SEEK Foo.F1
>   IF NOT FOUND()
>      APPEND BLANK
>      REPLACE F1 WITH Foo.F1
>   ENDIF
>   SELECT Foo
>ENDSCAN
>

These codes take 0.01 sec to run where as sql statement takes 0.15 sec to run

thanx
suhashegde