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
 
 
 
 

Reply via email to