>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