Article View: borland.public.vdbase.data.sql
Article #1286Parameters for report
From: Andrea Starz
Date: Mon, 16 Feb 1998 00:00
Date: Mon, 16 Feb 1998 00:00
21 lines
1071 bytes
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-mailShow 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