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
