What Charles indicated below plus: You have a space missing between t8 and WHERE Use: (t7.cityhome & t7.statehome & (CTXT(t7.pocodehome))) Instead of: (t7.cityhome +' ' + t7.statehome +' '+ (CTXT(t7.pocodehome))) Also, I restrict the length of my lines to 80 characters, I am not sure if this is still true, but at one time CODELOCK would have problems with lines longer that 80 characters. Javier,
Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ====================================================== -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Parks Sent: Thursday, July 08, 2004 9:13 AM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: syntax error -help please 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 --- RBG7-L =======================3D======================= D= TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) =======================3D======================= D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: INTRO =======================3D======================= D= TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D======================= D= TO SEARCH ARCHIVES: Send a plain text email to [EMAIL PROTECTED] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. =======================3D======================= D=
<<attachment: winmail.dat>>
