Query parameters

Article View: borland.public.vdbase.data.sql

Article #1351

Back to borland.public.vdbase.data.sql Previous Next

#1351

From: Andrea Starz
Date: Mon, 09 Feb 1998 00:00

15 lines
754 bytes

When i run this query, an error message display:
" Variable sCod not defined "
but sCod is defined as a PUBLIC char variable (ex. value is 'LC1')

--Database:CONDO
SELECT   (INQ + ' - ')  + COGN  LB_INQU, COGN, COD
FROM "inqu.dbf" Inqu
where Inqu.COD = :sCod
ORDER BY COD, COGN

Why?
Thanks 

Andrea

Technical Details

Message-ID: <34DF082C.7CC4@mbox.vol.it>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,5beab218a550fa1c,start
X-Google-Attributes: gidff5a1,public
From: Andrea Starz <starzand@mbox.vol.it>
Subject: Query parameters
Date: 1998/02/09
Message-ID: <34DF082C.7CC4@mbox.vol.it>
X-Deja-AN: 323419913
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql