>>>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

That's right. The same result will return this statement (it'll work on VFP8):

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

And what do you want to get?

Janusz Czudek
WORD Software
http://www.wordsoft.com.pl