Bhavbhuti,

Would it work if you access the view from VFP using SPT?

>Hi all
>
>I have these 2 views both derieve from the same parent tables. But one views calculations are required in the other view, so the other view is based on the original parent tables as well as the calc. view.
>
>In VFP this works fines. But when called from an external program via ODBC, the view hangs hanging the external program.
>
>The calculation is complex also using another table and the result is used a couple of time in this hanging view, otherwise I would have copy pasted the calc. into this hanging view.
>
>Please advise.