>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