>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.