Here is the definition:
CREATE VIEW DuesBill +
(MemberId, +
OfficeID, +
MemberType, +
SubClass, +
LastName, +
FirstName, +
Initial, +
NickName, +
MailPref, +
FaxPref, +
DateJoined, +
MbrStatus, +
MbrStatusDate, +
SSN, +
RElicense, +
Birthday, +
MbrEmail, +
BillingCode, +
BillToOffice, +
ReinstateCode, +
ReinstateDate, +
MPdex, +
FPdex, +
HMDex, +
MaDex, +
OfDex, +
DuesMonth, +
LocalDues, +
StateDues, +
NatlDues, +
Misc1, +
Misc2, +
Misc3, +
Misc4, +
Initiation, +
LocalBalFwd, +
StateBalFwd, +
NatlBalFwd, +
Misc1BalFwd, +
Misc2BalFwd, +
Misc3BalFwd, +
Misc4BalFwd, +
InitiationBalFwd, +
LateFeeFwd, +
StatePdDate, +
NatlPdDate, +
RPACPdDate, +
WavLocalDues, +
WavStateDues, +
WavNatlDues, +
WavMisc1, +
WavMisc2, +
WavMisc3, +
WavMisc4, +
WavLateFee, +
NetLocalBal, +
NetStateBal, +
NetNatlBal, +
NetM1Bal, +
NetM2Bal, +
NetM3Bal, +
NetM4Bal, +
NetInitBal, +
LateFeeDate, +
LateFee) +
AS SELECT +
T1.MemberId, +
T1.OfficeID, +
T1.MemberType, +
T4.DuesClass, +
T1.LastName, +
T1.FirstName, +
T1.Initial, +
T1.NickName, +
T1.MailPref, +
T1.FaxPref, +
T1.DateJoined, +
T1.MbrStatus, +
T1.MbrStatusDate, +
T1.SSN, +
T1.RElicense, +
T1.Birthday, +
T1.MbrEmail, +
T1.BillingCode, +
T1.BillToOffice, +
T1.ReinstateCode, +
T1.ReinstateDate, +
T1.MPdex, +
T1.FPdex, +
T1.HMDex, +
T1.MaDex, +
T1.OfDex, +
T4.DuesMonth, +
T4.A, +
T4.B, +
T4.C, +
T4.D, +
T4.E, +
T4.F, +
T4.G, +
T3.i, +
T3.aBalFwd, +
T3.bBalFwd, +
T3.cBalFwd, +
T3.dBalFwd, +
T3.eBalFwd, +
T3.fBalFwd, +
T3.gBalFwd, +
T3.iBalFwd, +
T3.LateFeeFwd, +
T3.bPdDate, +
T3.cPdDate, +
T3.hPdDate, +
T3.aWav, +
T3.bWav, +
T3.cWav, +
T3.dWav, +
T3.eWav, +
T3.fWav, +
T3.gWav, +
T3.WavLateFee, +
(IFEQ(T3.aWav,'Y',0,T4.A)+T3.aBalFwd),
+
(IFEQ(T3.bWav,'Y',0,T4.B)+T3.bBalFwd),
+
(IFEQ(T3.cWav,'Y',0,T4.C)+T3.cBalFwd),
+
(IFEQ(T3.dWav,'Y',0,T4.D)+T3.dBalFwd),
+
(IFEQ(T3.eWav,'Y',0,T4.E)+T3.eBalFwd),
+
(IFEQ(T3.fWav,'Y',0,T4.F)+T3.fBalFwd),
+
(IFEQ(T3.gWav,'Y',0,T4.G)+T3.gBalFwd),
+
(T3.I+T3.IBalFwd), +
t4.LateFeeDate, +
t4.LateFee +
FROM +
MemStats T1, +
DuesStatus T3, +
DuesAmt T4 +
WHERE T1.MemberId = T3.MemberID +
AND T1.MemberID = T4.MemberID +
Union Sel +
MemberId, +
OfficeID, +
MemberType, +
SubClass, +
LastName, +
FirstName, +
Initial, +
NickName, +
MailPref, +
FaxPref, +
DateJoined, +
MbrStatus, +
MbrStatusDate, +
SSN, +
RElicense, +
Birthday, +
MbrEmail, +
BillingCode, +
BillToOffice, +
ReinstateCode, +
ReinstateDate, +
MPdex, +
FPdex, +
HMDex, +
MaDex, +
OfDex, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null, +
null +
from MemStats +
whe subclass not in (sel DuesClass
from DuesAmt) +
and MbrStatus in ('A','P')
Ben
On 18 Apr 2001, at 14:21, Bill Downall wrote:
> On Wed, 18 Apr 2001 12:11:18 +0100, Ben Petersen wrote:
>
> >Sel * from viewName
> >and
> >Sel * from viewName whe IDcol = .vIdVal
>
> Ben,
>
> UNLOAD STR FOR viewname, and show us the whole view definition.
>
> Bill
>
>
>
>
>
