[RBASE-L] - BROWSE Window View Wierdness

[Bruce Chitiea]

All:

Typo aside, to simplify the message, 'vwGoodToGo' was used to alias view: vwMonthlyIncomeSummary:

VIEW: vwMonthlyIncomeSummary

CREATE VIEW vwMonthlyIncomeSummary AS +
SELECT t1.fymid, deptotal, fyyrnum, +
cmyrnum, cmyrabbr, unitdues, unitcount, +
budgetincome, (deptotal-budgetincome) AS depvariance +
FROM vwmonthlydeposittotal t1, +
vwmonthlybudgetincome t2 +
WHERE t2.fymid = t1.fymid +
ORDER BY t1.fymid

******************************

Which draws on two precursor views:

VIEW: vwMonthlyDepositTotal

CREATE VIEW vwMonthlyDepositTotal AS +
SELECT fymid,fyyrnum,cmyrnum,cmyrabbr, SUM(depamt) AS deptotal +
FROM deposit t1,fymonth t2,zcalmonth t3 +
WHERE +
t2.fymid = t1.fymid AND +
t2.cmid = t3.cmid +
GROUP BY fymid,fyyrnum,cmyrnum,cmyrabbr +
ORDER BY fymid

******************************

and:

VIEW: vwMonthlyBudgetIncome

CREATE VIEW vwMonthlyBudgetIncome +
(fymid,unitcount,unitdues,budgetincome) AS +
SELECT fymid,unitcount,SUM(uaamt),(SUM(uaamt) * unitcount) +
FROM ua2fym t1,uc2fym t2 +
WHERE t2.fymid=t1.fymid +
GROUP BY fymid,unitcount +
ORDER BY fymid 

******************************

1. All three views perform properly at the R> Prompt.

2. vwMonthlyDepositTotal and vwMonthlyBudgetIncome both perform properly in BROWSE windows

3. Only vwMonthlyIncomeSummary fails in BROWSE windows as described in the earlier message with:

'Invalid Cursor State (2645)'

'The requested _expression_ does not exist (2144)'

Thanks for your help.

Bruce