|
I am attempting to create a view for use in a
report. Here is my code
CREATE VIEW rushreports +
AS SELECT + t5.rushnum AS rprushnum, + t5.contamount AS rpdonamount, + t5.contirbdate AS rpdondate, + t6.idnum AS rpidnum, + (t7.firstname& t7.middleinit& t7.lastname& t7.nameabbrev) AS rpname, + t7.homeaddr1 AS rpaddress, + t7.homeaddr2 AS rpaddress2,(t7.cityhome +' ' + t7.statehome +' '+ (CTXT(t7.pocodehome))) AS rpcsz, + t8.donortotal AS rpdontotal, + t6.pinlevel AS rppinlev + FROM rushtrans t5,rushmaster t6, people t7, rushcontview t8where t5.receiptdate IS NULL AND t5.rushnum = t6.rushnum AND t6.idnum =t7.idnum AND t8.donornumber =(CTXT(t5.rushnum)) RETURN all the columns are valid, tables are valid and
R:Syntax returns "no errors found" but at the R:Prompt i get syntax error
2367. here are some decoding tips
t8.donornumber is CTXT of t5.rushnum in a
view
the components of rprushnum, rdonoramount, rpidnum
are integers
rpdondate and receiptdate are dates
except for pocodehome(integer) the remaining fields
are text
Thank you for any guidance you can
provide.
Tom
|
- [RBG7-L] - Re: Tracking Intermediate errors David M. Blocker
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
- [RBG7-L] - Re: Tracking Intermediate errors David M. Blocker
- [RBG7-L] - Re: Tracking Intermediate errors Jim Limburg
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
- [RBG7-L] - Re: Tracking Intermediate errors MikeB
- [RBG7-L] - Re: Tracking Intermediate errors MikeB
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
- [RBG7-L] - Re: Tracking Intermediate errors Thomas Eldred
- [RBG7-L] - Re: Tracking Intermediate errors jlimburg
