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


See message #771302