Would you please remove me from this service until further notice. My email is filling up.
Thank you. Scott SCOTT STRICKER [email protected] PHONE 214-866-2127 FAX 972-499-0068 15851 N. Dallas Parkway Suite 1000 ADDISON, TEXAS 75001 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Wednesday, January 28, 2009 4:39 PM To: [email protected] Subject: [RBASE-L] - Re: ERROR - invalid text value <2418> At 05:17 PM 1/28/2009, Stricker, Scott wrote: >PROJ tTBLTEMX FRO TBLTEMP USI ALL WHE CATE=CONT OR CATE=REC OR CATE=LRP + >AND CODEE = .VCOD ORDER BY REMDAT=ASC Use must use database CHARACTER settings for QUOTES when comparing or providing TEXT values on the right side of the equation, such as "=". Try the following, assuming your database character settings are set to double quotes. PROJECT tTBLTEMX FROM TBLTEMP USING ALL WHERE + CATE = "CONT" OR CATE = "REC" OR CATE = "LRP" + AND CODEE = .VCOD ORDER BY REMDAT ASC OR PROJECT tTBLTEMX FROM TBLTEMP USING ALL WHERE + CATE IN (CONT, REC, LRP) + AND CODEE = .VCOD ORDER BY REMDAT ASC Hope that helps! Very Best R:egards, Razzak. --------------------------------------------------------- Registered Representative of and securities offered through MML Investors Services, Inc. (MMLISI). Home Office located at 1295 State Street, Springfield, MA 01111, (413) 737-8400. Member SIPC (www.sipc.org). Transactions may not be accepted by e-mail, fax, or voicemail. This e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies. --------------------------------------------------------- --- RBASE-L =======================3D=======================3 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=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 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=======================3 D=
