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.

Retrieval Arguments

7 posts in PB Infomaker Report Writer Last posting was on 1997-10-17 21:57:42.0Z
Edward Knudholt Posted on 1997-09-17 20:37:10.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 17 Sep 1997 16:37:10 -0400
From: Edward Knudholt <eknudhol@knudholt.cnchost.com>
Reply-To: eknudhol@knudholt.cnchost.com
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
Subject: Retrieval Arguments
X-Priority: 3 (Normal)
Content-Type: multipart/alternative; boundary="------------76AFA741EF3B68FC70C301B7"
Lines: 40
Message-ID: <348_34203F75.22056FE0@knudholt.cnchost.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7459
Article PK: 244514

The reports I have created require the user to specify 3-6 "Retrieval Arguments", on most these are "String" and the others they are "String Arrays".  While entering data for all the arguments is an option, it is not required for the reports, this causes the user to supply a dummy argument ('.') to continue the report since an IM5 error message is displayed if an argument does not contain some kind of value.
 

  • Is there a way around this?
  • Can I create my own data entry form to request the report arguments that are displayed inplace of the default dialog?
Thanks

Ed Knudholt
 


Christopher F Jackson Posted on 1997-10-09 03:21:28.0Z
Newsgroups: sybase.public.infomaker.general
Date: Wed, 08 Oct 1997 23:21:28 -0400
From: Christopher F Jackson <cfjackson@earthlink.net>
X-Mailer: Mozilla 4.03 [en] (Win95; I)
MIME-Version: 1.0
Subject: Re: Retrieval Arguments
Content-Type: multipart/alternative; boundary="------------D202E5CE1B11DB448D7D104D"
Lines: 57
Message-ID: <348_343C4DB7.7BF48B29@earthlink.net>
References: <348_34203F75.22056FE0@knudholt.cnchost.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7434
Article PK: 244489

I have the same problems ,also do you know if there is a way to keep your last selective arguments that you enter reappear when the window reopens this would be very useful since i have about 7 arguments a user must enter and most of the time its the same.

Edward Knudholt wrote:

 The reports I have created require the user to specify 3-6 "Retrieval Arguments", on most these are "String" and the others they are "String Arrays".  While entering data for all the arguments is an option, it is not required for the reports, this causes the user to supply a dummy argument ('.') to continue the report since an IM5 error message is displayed if an argument does not contain some kind of value.
 
  • Is there a way around this?
  • Can I create my own data entry form to request the report arguments that are displayed inplace of the default dialog?
Thanks

Ed Knudholt
 

 


Stephen Dupre[Powersoft Tools, Sybase Inc.] Posted on 1997-10-15 01:58:46.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 14 Oct 1997 21:58:46 -0400
From: "Stephen Dupre[Powersoft Tools, Sybase Inc.]" <sdupre@powersoft.com>
Reply-To: sdupre@powersoft.com
Organization: Powersoft Tools
X-Mailer: Mozilla 3.0Gold (WinNT; U)
MIME-Version: 1.0
Subject: Re: Retrieval Arguments
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 52
Message-ID: <348_34442356.14EA@powersoft.com>
References: <348_34203F75.22056FE0@knudholt.cnchost.com> <348_343C4DB7.7BF48B29@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7432
Article PK: 244487


Christopher F Jackson wrote:
>
> I have the same problems ,also do you know if there is a way to keep
> your last selective arguments that you enter reappear when the window
> reopens this would be very useful since i have about 7 arguments a
> user must enter and most of the time its the same.
>
> Edward Knudholt wrote:
>
> The reports I have created require the user to specify 3-6
> "Retrieval Arguments", on most these are "String" and the
> others they are "String Arrays". While entering data for
> all the arguments is an option, it is not required for the
> reports, this causes the user to supply a dummy argument
> ('.') to continue the report since an IM5 error message is
> displayed if an argument does not contain some kind of
> value.
>
>
> * Is there a way around this?
> * Can I create my own data entry form to request the
> report arguments that are displayed inplace of the
> default dialog?
>
> Thanks
>
> Ed Knudholt
>
>
>

Unfortuntely, the retrieval arg issue is an enhancement. You'd have to
put up PB to use your own retrieval argument dialog.

Try a read-only form of type freeform or grid. Use Specify/Apply
Criteria from the menu. Querymode (Specify/Apply Criteria) is one area
of Powerbuilder where going back and forth from Specify/Apply Criteria
restores the previously entered criteria.

Specify/Apply Criteria is basically building a WHERE clause on-the-fly
based on whatever data you enter into column(s) so it's even more
flexible. Retrieval Args means you have a hard-coded WHERE clause
where you're just filling in placeholder values to go into the WHERE
clause.

WHERE emp_id = :emp_id and
dept_id = :dept_id

If you want to restrict the WHERE clause generated by Specify/Apply
Criteria mode in the form or the columns the user can put criteria into,
just set their tab orders to zero in the painter (freeform).

Stephen Dupre
Powersoft Tools


Terry Dykstra Posted on 1997-10-15 16:43:50.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra" <tdykstra@cfol.ab.ca>
Subject: Re: Retrieval Arguments
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Wed, 15 Oct 1997 12:43:50 -0400
Lines: 71
Message-ID: <348_01bcd991$a63f8fc0$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_34203F75.22056FE0@knudholt.cnchost.com> <348_343C4DB7.7BF48B29@earthlink.net> <348_34442356.14EA@powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7431
Article PK: 244486

You might want to consider using the 'Prompt For Criteria' option instead
of retrieval arguments. THis allows you to leave any columns blank that
don't require a value. If you specify edit styles for these columns (like
dropdown datawindow or dropdown listbox), you can make the retrieval much
easier, since the user can then select from predefined values.
The downside is of course that the user can also put in as many or as few
arguments as possible, leading potentially to run-away queries.

Terry Dykstra (TeamPS)

Stephen Dupre[Powersoft Tools, Sybase Inc.] <sdupre@powersoft.com> wrote in
article <34442356.14EA@powersoft.com>...
> Christopher F Jackson wrote:
> >
> > I have the same problems ,also do you know if there is a way to keep
> > your last selective arguments that you enter reappear when the window
> > reopens this would be very useful since i have about 7 arguments a
> > user must enter and most of the time its the same.
> >
> > Edward Knudholt wrote:
> >
> > The reports I have created require the user to specify 3-6
> > "Retrieval Arguments", on most these are "String" and the
> > others they are "String Arrays". While entering data for
> > all the arguments is an option, it is not required for the
> > reports, this causes the user to supply a dummy argument
> > ('.') to continue the report since an IM5 error message is
> > displayed if an argument does not contain some kind of
> > value.
> >
> >
> > * Is there a way around this?
> > * Can I create my own data entry form to request the
> > report arguments that are displayed inplace of the
> > default dialog?
> >
> > Thanks
> >
> > Ed Knudholt
> >
> >
> >
>
> Unfortuntely, the retrieval arg issue is an enhancement. You'd have to
> put up PB to use your own retrieval argument dialog.
>
> Try a read-only form of type freeform or grid. Use Specify/Apply
> Criteria from the menu. Querymode (Specify/Apply Criteria) is one area
> of Powerbuilder where going back and forth from Specify/Apply Criteria
> restores the previously entered criteria.
>
> Specify/Apply Criteria is basically building a WHERE clause on-the-fly
> based on whatever data you enter into column(s) so it's even more
> flexible. Retrieval Args means you have a hard-coded WHERE clause
> where you're just filling in placeholder values to go into the WHERE
> clause.
>
> WHERE emp_id = :emp_id and
> dept_id = :dept_id
>
> If you want to restrict the WHERE clause generated by Specify/Apply
> Criteria mode in the form or the columns the user can put criteria into,
> just set their tab orders to zero in the painter (freeform).
>
> Stephen Dupre
> Powersoft Tools
>


Edward Knudholt Posted on 1997-10-17 19:33:21.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 17 Oct 1997 15:33:21 -0400
From: Edward Knudholt <eknudhol@knudholt.cnchost.com>
Reply-To: eknudhol@knudholt.cnchost.com
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
To: Terry Dykstra <tdykstra@cfol.ab.ca>
Subject: Re: Retrieval Arguments
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 35
Message-ID: <348_3447BD81.A4F931E0@knudholt.cnchost.com>
References: <348_34203F75.22056FE0@knudholt.cnchost.com> <348_343C4DB7.7BF48B29@earthlink.net> <348_34442356.14EA@powersoft.com> <348_01bcd991$a63f8fc0$8366e4cf@tdykstra.cfol.ab.ca>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7426
Article PK: 244481

There is still a missunderstanding about what I am looking for, I
think. What I wanted to use the 'Form' for was to feed my reports the
selection criteria and from what I see when building the 'Form' you need
to specify either a Query or a table and can not have a standalone form
that defines variables that can be used later as criteria in the
reports. Unless there is a way to call the form from the report when it
is executed or show the report once the 'Form' has selected data based
on the criteria, I don't see a way to make this work.

What I would like to be able to do is build a form with either bound
DDDW's or use edit controls (for text entry) and prompt a user for
criteria and be able to put some logic behind it. I have asked this
question of a number of PB developers (most of them don't use IM) but is
there a way to add PB objects into IM or can I move my IM reports to
PB? If so, how is it done? (I am a VC++ person and very little
background with PB5 and IM, but I feel that if I can do that I would be
able to provide the product my clients expect.

I have not been able to find any books on IM and the books I have found
on PB5 do not go into any detail on IM.

If you need more info and feel that a phone call would work better, let
me know and I'll call you or get you my number.

Thanks for your help

Ed


Stephen Dupre[Powersoft Tools, Sybase, Inc.] Posted on 1997-10-17 21:57:42.0Z
Newsgroups: sybase.public.infomaker.general
Date: Fri, 17 Oct 1997 17:57:42 -0400
From: "Stephen Dupre[Powersoft Tools, Sybase, Inc.]" <sdupre@powersoft.com>
Reply-To: sdupre@powersoft.com
Organization: Powersoft Corporation
X-Mailer: Mozilla 3.0 (WinNT; I)
MIME-Version: 1.0
Subject: Re: Retrieval Arguments
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 77
Message-ID: <348_3447DF56.A8E@powersoft.com>
References: <348_34203F75.22056FE0@knudholt.cnchost.com> <348_343C4DB7.7BF48B29@earthlink.net> <348_34442356.14EA@powersoft.com> <348_01bcd991$a63f8fc0$8366e4cf@tdykstra.cfol.ab.ca> <348_3447BD81.A4F931E0@knudholt.cnchost.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7425
Article PK: 244480


Edward Knudholt wrote:
>
> There is still a missunderstanding about what I am looking for, I
> think. What I wanted to use the 'Form' for was to feed my reports the
> selection criteria and from what I see when building the 'Form' you need
> to specify either a Query or a table and can not have a standalone form
> that defines variables that can be used later as criteria in the
> reports. Unless there is a way to call the form from the report when it
> is executed or show the report once the 'Form' has selected data based
> on the criteria, I don't see a way to make this work.
>
> What I would like to be able to do is build a form with either bound
> DDDW's or use edit controls (for text entry) and prompt a user for
> criteria and be able to put some logic behind it. I have asked this
> question of a number of PB developers (most of them don't use IM) but is
> there a way to add PB objects into IM or can I move my IM reports to
> PB? If so, how is it done? (I am a VC++ person and very little
> background with PB5 and IM, but I feel that if I can do that I would be
> able to provide the product my clients expect.
>
> I have not been able to find any books on IM and the books I have found
> on PB5 do not go into any detail on IM.
>
> If you need more info and feel that a phone call would work better, let
> me know and I'll call you or get you my number.
>
> Thanks for your help
>
> Ed

The Infomaker exe itself contains all the objects for the report(s).
You can use the function LibraryDirectory() to query the reports in the
executable built in Infomaker - put the EXE in place of the PBL name in
the argument list for LibraryDirectory(). You could have to build a
simple MDI application in PB to query the Infomaker exe for the
reports.

The syntax for parsing what LibraryDirectory() returns - a nice list of
reports - is encapsulated in the IMSTYLE5.PBL that comes with PB5.
Search for LibraryDirectory() in the source. This will present a list
of reports for the user to pick from that you can place on a
dropdownlistbox on a window for the user.

Once a report is selected from this listbox, getting the retrieval
arguments out of a report(s) to put into a dialog is not trivial. There
is no Describe("datawindow.arguments") that you would use to construct a
dialog to give the user for each report they choose when they run this
PB app.

There is a snippet of code in PFC that does do this - it basically
parses the datawindow source for the report and gives you back an array
of arguments + datatypes if memory serves. The service is in
pfc_n_cst_dwsrv in PFCDWSRV.PBL

of_dwarguments()

You can see how bad the code is...

You could build this thing using PB and use the report(s) from the
Infomaker exe. Another option would be to test this completely in
Powerbuilder and perhaps encapsulate the working code into an Infomaker
custom form style for use in Infomaker that could be made available to
all your users.


Stephen Dupre
Powersoft Tools


Edward Knudholt Posted on 1997-10-13 18:54:24.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 13 Oct 1997 14:54:24 -0400
From: Edward Knudholt <eknudhol@knudholt.cnchost.com>
Reply-To: eknudhol@knudholt.cnchost.com
X-Mailer: Mozilla 4.01 [en] (Win95; I)
MIME-Version: 1.0
To: Christopher F Jackson <cfjackson@earthlink.net>
Subject: Re: Retrieval Arguments
X-Priority: 3 (Normal)
Content-Type: multipart/alternative; boundary="------------C0C59DD4B53B313D2F22A211"
Lines: 85
Message-ID: <348_34426E5F.E5790FA2@knudholt.cnchost.com>
References: <348_34203F75.22056FE0@knudholt.cnchost.com> <348_343C4DB7.7BF48B29@earthlink.net>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7433
Article PK: 244488

Not sure, I think there is a way to create GLOBALs which you could populate when the window is accessed but I have not done this.  I have had so many problems creating what I consider simple reports that I am most likely going recommend either having a PB developer develop the reports in PB5.x (not sure if this would solve any of the issues) or switch to another report tool.

Christopher F Jackson wrote:

 

I have the same problems ,also do you know if there is a way to keep your last selective arguments that you enter reappear when the window reopens this would be very useful since i have about 7 arguments a user must enter and most of the time its the same.

Edward Knudholt wrote:

 The reports I have created require the user to specify 3-6 "Retrieval Arguments", on most these are "String" and the others they are "String Arrays".  While entering data for all the arguments is an option, it is not required for the reports, this causes the user to supply a dummy argument ('.') to continue the report since an IM5 error message is displayed if an argument does not contain some kind of value.
 
  • Is there a way around this?
  • Can I create my own data entry form to request the report arguments that are displayed inplace of the default dialog?
Thanks

Ed Knudholt
 

 
 

--
-----------------------------
Edward Knudholt
eknudhol@knudholt.cnchost.com