[V4MD ValentinaStudio Mac] some questions

[Ivan Smahin]

Hello peter,

Monday, April 4, 2005, 1:12:49 PM, you wrote:


ps> 3. SQL - API Question:

ps> i have a table "t"  with e.g. 50 fields, one of them is named "test"
ps> in "test" records contain strings, sometimes repeated, i do not know
ps> what is in there
ps> e.g.:
ps> id 1 "aaa"
ps> id 2 "bbb"
ps> id 3 "aaa"
ps> id 4 "ccc"
ps> id 5 "ddd"
ps> id 6 "aaa"
ps> id 7 "bbb"

ps> i want to have cursor OR VSet containing all strings only ONE time: -->
ps> "aaa" , "bbb" , "ccc" , "ddd"

In SQL way you can use just DISTINCT keyword:

select DISTINCT f2 from T1



-- 
Best regards,
 Ivan                            mailto:IvanSmahin at public.kherson.ua