[RBASE-L] - RE: Syntax Problem

[Javier Valencia]

Dan: A few things to consider: Is whval0 pre-defined with the correct type and value? Does a jobnum with the value of vhval0 exist? Make sure that you are not using O (oh) intead of 0 (zero) Have you cheeked that the quotes setting is still “? Create a variable: SET VAR vquote = (CVAL('QUOTES')) And trace the code and see what is the value of vquote and vhval0 before you execute the command Other than that is should work OK. 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: rbase-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Dan Champion Sent: Monday, May 15, 2006 9:53 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Syntax Problem   Good morning,   I had some older code fail today, and I can't see why. Can anyone see this? Setup:  Rbase 6.5++ Windows PRINT  job_rpt  WHERE  jobnum = .whval0 fails where PRINT  job_rpt  WHERE  jobnum = "18074" works fine. The variable whva10 is Text, Quotes are ".  What is the difference, and why could this just start failing this morning with no changes to the database that I know of? Dan Champion  Service Department Manager Vredevoogd Heating & Cooling     Grandville, MI. 49418             616-534-8329     616-299-7420 cell