Thank you, the missing space was the secret ingredient,
Tom ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, July 08, 2004 10:26 AM Subject: [RBG7-L] - RE: syntax error -help please > Tom - > > Your syntax has a missing space after the word "WHERE". > > Sami > > ------------------------------------------ > Sami Aaron > Software Management Specialists > 19312 W 63rd Terr > Shawnee KS 66218 > 913-915-1971 > mailto:[EMAIL PROTECTED] > www.softwaremgmt.com > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thomas Eldred > Sent: Thursday, July 08, 2004 9:02 AM > To: RBG7-L Mailing List > Subject: [RBG7-L] - syntax error -help please > > > 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 > >
