🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Parameters for report

#1286
From: Andrea Starz
Date: Mon, 16 Feb 1998 00:00
21 lines
1071 bytes
I have created a report with a query with parameters.

I have added the 'params' vector at property of query with the same name
of the parameter
ex:
sql="select .... where extract(year from fld1)=:var1
                   and extract(month from fld1)= :var2 ..."
params["var1"]=1990  
params["var2"]=2     

all the parameters are numbers (integer), but a message
" variable var1 not defined " occour and it not work.

In inspector the variables are present but not defined (null) and if i
set the value it's not saved, and the tool button in params generator is
not active. 

Where is the problem?

Andrea
Technical Details
Message-ID: <34E87A93.5915@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,bb30a7a03a7301aa,start
X-Google-Attributes: gidff5a1,public
From: Andrea Starz <starzand@mbox.vol.it>
Subject: Parameters for report
Date: 1998/02/16
Message-ID: <34E87A93.5915@mbox.vol.it>
X-Deja-AN: 325595756
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql