Hi Sergey

Like I mentioned in the previous reply I was trying to make the calcualtion views into smaller and smaller views, here is the culprit:

SELECT ROUND(LV_LKFCR1.BFCR1 / LV_LKFUELCONSTIME.BFCT, 2) AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

The following 2 works, but together as above they dont work through ODBC in Report Manager:

SELECT LV_LKFUELCONSTIME.BFCT AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

SELECT LV_LKFCR1.BFCR1 AS BSFC1, ;
		LV_LKSRATINGTEST.IID ;
	FROM VSO3VIEWS!LV_LKTRATINGTEST ;
		JOIN VSO3VIEWS!LV_LKSRATINGTEST ;
				ON LV_LKTRATINGTEST.IID = LV_LKSRATINGTEST.IPID ;
		JOIN VSO3VIEWS!LV_LKFCR1 ;
				ON LV_LKSRATINGTEST.IID = LV_LKFCR1.IID ;
		JOIN VSO3VIEWS!LV_LKFUELCONSTIME ;
				ON LV_LKSRATINGTEST.IID = LV_LKFUELCONSTIME.IID

>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.