>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.
From which record this date should come? If you don't care or it's the same for cauktcid than you can use MIN() or MAX() function.
Select cauktcid, DTOC(MAX(regdate)) as datum from auktlogg group by 1 into cursor cTempAuktion
--sb--