>>Hi All,
>>
>>How to get this working in VFP8 without setting ENGINEBEHAVIOR TO 70 ?
>>
>>

Select cauktcid, DTOC(regdate) as datum from auktlogg group by 1 into cursor cTempAuktion

>>
>>I want to have one record for each cauktid in table auktlogg with the date.
>
>And what about DISTINCT clause? Try this:
>
>

>Select distinct cauktcid, DTOC(regdate) as datum from auktlogg into cursor cTempAuktion
>

>
>Maybe it will work for you :)
>
>Janusz Czudek
>WORD Software
>http://www.wordosft.com.pl

I tried that, but it gives me all distinct values of cauktid and datum together