Might try putting the column names after the view name and before the as select.
This would look something like CREATE VIEW Rushreports (rprushnum, ...) AS SELECT t5.rushnum, ... 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)) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Thomas Eldred Posted At: Thursday, July 08, 2004 9:02 AM Posted To: RB7-L Conversation: [RBG7-L] - syntax error -help please 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
