[RBASE-L] - RE: Syntax Problem

[Dawn Oakes]

Dan,

Your variable is defined as whva10 (w-h-v-a the number 1, zero), your print statement is using w-h-v-a-L-zero.

Dawn

---

From: Dan Champion [mailto:[EMAIL PROTECTED]
Sent: Monday, May 15, 2006 11:29 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Syntax Problem

Javier,
   Yes, The dialog command just before the print that creates whva10 makes it be text, however I did test this at the R:

sho v w*
variable              = value             type
whva10                  18074                text

shows the variable as a text value

both print statements side by side, one works one doesn't from the R:

PRINT  job_rpt  WHERE  jobnum = .whval0
fails where
PRINT  job_rpt  WHERE  jobnum = "18074"


This is all from the R:prompt... how can this even be true?

Dan


At 11:06 AM 5/15/2006, you wrote:

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:rbase-l@rbase.com]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

Dan Champion

 Service Department Manager
Vredevoogd Heating & Cooling
    Grandville, MI. 49418    
        616-534-8329
    616-299-7420 cell