>I have inheritedthe an application written in VFP5 that I am migrating to VFP9.
>
>There is a very complex view that in VFP9 complains that the group by is missing or invalid.
>
>In the VFP5 view, there is no group by clause. I understand basically what the error means, etc. but...
>
>In the past, to convert the SQL, I often created more than one query and combined them to get the same result.
>
>The issue I have this time is, this is a complex view and it is updateable. Any ideas on how to do it in one, keeping it as a single updateable view?
>
>i.e. how to add the necessary group by clause that would return the same result?
>
>TIA,
>Mike
Michael,
Can you post the view definition? You would need to make an aggregate function for all fields, which are not included into Group By clause or you may need to include all fields into group by. I am not sure, though, how can you have updatable view with GROUP BY.
If it's not broken, fix it until it is.
My Blog