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