Hi Steve,

Actually there is only one date per cauktid. Of course i could set enginebehavior , but i am going thru all selects and views in the app and i want to make everything VFP8 compatible.




>Torgny,
>
>So you can have more than one datum for a given cauktid? How would VFP know which date to give you?
>
>If you don't care which one it gives you, what is wrong with setting enginebehavior, and then setting it back after the query?
>
>< UPDATE >
>I jumped in late...I see you have your answer now...
>
>>>>
>>>>How to get this working in VFP8 without setting ENGINEBEHAVIOR TO 70 ?
>>>>
>>
>>I tried that, but it gives me all distinct values of cauktid and datum together