Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Inputting Parameters

5 posts in PB Infomaker Report Writer Last posting was on 1998-03-24 17:58:06.0Z
Jim Tobin Posted on 1998-03-22 15:26:52.0Z
Newsgroups: sybase.public.infomaker.general
Date: Sun, 22 Mar 1998 10:26:52 -0500
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: Inputting Parameters
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <348_35152DBB.195CADD2@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7208
Article PK: 243238

Hi!

I cna't figure out how to input a parameter into a report that is to be
used to determine criteria that is to be printed on the report. The
problem is: I need to input the # of days the user wants to use to
filter out contracts that will expire within the next (1-x) days. The #
of days input will then be used in the daysafter(d,d) function.

Thnaks, Jim


Terry Dykstra [TeamPS] Posted on 1998-03-23 18:27:12.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Inputting Parameters
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Mon, 23 Mar 1998 13:27:12 -0500
Lines: 20
Message-ID: <348_01bd5692$97d56300$3301020a@tdykstra>
References: <348_35152DBB.195CADD2@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7207
Article PK: 243236

Create a retrieval argument of type number. Ignore the error you get when
IM warns that you aren't using it in the Select statement. Then create a
computed field using daysafter(the_date, the_retrieval_argument)
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jim Tobin <jimtobin@compuserve.com> wrote in article
<35152DBB.195CADD2@compuserve.com>...
> Hi!
>
> I cna't figure out how to input a parameter into a report that is to be
> used to determine criteria that is to be printed on the report. The
> problem is: I need to input the # of days the user wants to use to
> filter out contracts that will expire within the next (1-x) days. The #
> of days input will then be used in the daysafter(d,d) function.
>
> Thnaks, Jim
>
>


Jim Tobin Posted on 1998-03-24 01:16:33.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 23 Mar 1998 20:16:33 -0500
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Inputting Parameters
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 30
Message-ID: <348_35170971.4DF9E669@compuserve.com>
References: <348_35152DBB.195CADD2@compuserve.com> <348_01bd5692$97d56300$3301020a@tdykstra>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7203
Article PK: 243233

I was able to create a retrieval argument, but cannot get it to be accepted as
valid. I have the following in the Where clause of the SQL:

daysafter(column.name, today()) <= :NoDays

I am getting an error on the function 'daysafter'. When I click on functions
within the column the functions do not list daysfter().

Terry Dykstra [TeamPS] wrote:

> Create a retrieval argument of type number. Ignore the error you get when
> IM warns that you aren't using it in the Select statement. Then create a
> computed field using daysafter(the_date, the_retrieval_argument)
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin <jimtobin@compuserve.com> wrote in article
> <35152DBB.195CADD2@compuserve.com>...
> > Hi!
> >
> > I cna't figure out how to input a parameter into a report that is to be
> > used to determine criteria that is to be printed on the report. The
> > problem is: I need to input the # of days the user wants to use to
> > filter out contracts that will expire within the next (1-x) days. The #
> > of days input will then be used in the daysafter(d,d) function.
> >
> > Thnaks, Jim
> >
> >


Jim Tobin Posted on 1998-03-24 01:14:48.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 23 Mar 1998 20:14:48 -0500
From: Jim Tobin <jimtobin@compuserve.com>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
To: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Inputting Parameters
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 30
Message-ID: <348_35170908.D9AB92B0@compuserve.com>
References: <348_35152DBB.195CADD2@compuserve.com> <348_01bd5692$97d56300$3301020a@tdykstra>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7204
Article PK: 243234

I was able to create a retrieval argument, but cannot get it to be accepted as
valid. I have the following in the Where clause of the SQL:

daysafter(column.name, today()) <= :NoDays

I am getting an error on the function 'daysafter'. When I click on functions
within the column the functions do not list daysfter().

Terry Dykstra [TeamPS] wrote:

> Create a retrieval argument of type number. Ignore the error you get when
> IM warns that you aren't using it in the Select statement. Then create a
> computed field using daysafter(the_date, the_retrieval_argument)
> --
> Terry Dykstra [TeamPS]
> Canadian Forest Oil Ltd.
>
> Jim Tobin <jimtobin@compuserve.com> wrote in article
> <35152DBB.195CADD2@compuserve.com>...
> > Hi!
> >
> > I cna't figure out how to input a parameter into a report that is to be
> > used to determine criteria that is to be printed on the report. The
> > problem is: I need to input the # of days the user wants to use to
> > filter out contracts that will expire within the next (1-x) days. The #
> > of days input will then be used in the daysafter(d,d) function.
> >
> > Thnaks, Jim
> >
> >


Terry Dykstra [TeamPS] Posted on 1998-03-24 17:58:06.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <no_spam_tdykstra@cfol.ab.ca>
Subject: Re: Inputting Parameters
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Tue, 24 Mar 1998 12:58:06 -0500
Lines: 40
Message-ID: <348_01bd5757$b48aabc0$3301020a@tdykstra>
References: <348_35152DBB.195CADD2@compuserve.com> <348_01bd5692$97d56300$3301020a@tdykstra> <348_35170908.D9AB92B0@compuserve.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7200
Article PK: 243229

You cannot use report functions in the SELECT statement. daysafter() is an
IM function, not a SQL function. You must use the date-functions available
within your dbms.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Jim Tobin <jimtobin@compuserve.com> wrote in article
<35170908.D9AB92B0@compuserve.com>...
> I was able to create a retrieval argument, but cannot get it to be
accepted as
> valid. I have the following in the Where clause of the SQL:
>
> daysafter(column.name, today()) <= :NoDays
>
> I am getting an error on the function 'daysafter'. When I click on
functions
> within the column the functions do not list daysfter().
>
>
> Terry Dykstra [TeamPS] wrote:
>
> > Create a retrieval argument of type number. Ignore the error you get
when
> > IM warns that you aren't using it in the Select statement. Then create
a
> > computed field using daysafter(the_date, the_retrieval_argument)
> > --
> > Terry Dykstra [TeamPS]
> > Canadian Forest Oil Ltd.
> >
> > Jim Tobin <jimtobin@compuserve.com> wrote in article
> > <35152DBB.195CADD2@compuserve.com>...
> > > Hi!
> > >
> > > I cna't figure out how to input a parameter into a report that is to
be
> > > used to determine criteria that is to be printed on the report. The
> > > problem is: I need to input the # of days the user wants to use to
> > > filter out contracts that will expire within the next (1-x) days.
The #
> > > of days input will then be used in the daysafter(d,d) function.
> > >
> > > Thnaks, Jim
> > >
> > >
>
>
>
>