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.

SQL/Parameter Passing

3 posts in PB Infomaker Report Writer Last posting was on 1998-01-13 18:03:16.0Z
Mike Hyslop Posted on 1998-01-13 00:03:54.0Z
Newsgroups: sybase.public.infomaker.general
Date: Mon, 12 Jan 1998 17:03:54 -0700
From: Mike Hyslop <hyslopm@coynet.com>
Organization: Aldata Software Inc.
X-Mailer: Mozilla 4.04 [en] (Win95; I)
MIME-Version: 1.0
Subject: SQL/Parameter Passing
Content-Type: multipart/alternative; boundary="------------77FC62A5F29574DF2E73CD0F"
Lines: 30
Message-ID: <348_34BAAF6A.EAC725F5@coynet.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7325
Article PK: 244383

I would like to create an executable report with Infomaker 5.0 and be able to call that executable from other programs. The question is:

Is it possible to pass parameters with that call?

Preferably I would like to send SQL scripts, but I'd settle for being able to pass the name of a pregenerated report and just bypass any further button clicking on the default toolbar.

Anyone else tried this before?

Mike Hyslop


Stephen Dupre[Powersoft Tools, Sybase, Inc.] Posted on 1998-01-13 16:12:30.0Z
Newsgroups: sybase.public.infomaker.general
Date: Tue, 13 Jan 1998 11:12:30 -0500
From: "Stephen Dupre[Powersoft Tools, Sybase, Inc.]" <sdupre@powersoft.com>
Reply-To: sdupre@powersoft.com
Organization: Powersoft Corporation
X-Mailer: Mozilla 3.01Gold (WinNT; U)
MIME-Version: 1.0
Subject: Re: SQL/Parameter Passing
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 97
Message-ID: <348_34BB926E.751F@powersoft.com>
References: <348_34BAAF6A.EAC725F5@coynet.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7323
Article PK: 244379


Mike Hyslop wrote:
>
> I would like to create an executable report with Infomaker 5.0 and be
> able to call that executable from other programs. The question is:
>
> Is it possible to pass parameters with that call?
>
> Preferably I would like to send SQL scripts, but I'd settle for being
> able to pass the name of a pregenerated report and just bypass any
> further button clicking on the default toolbar.
>
> Anyone else tried this before?
>
> Mike Hyslop

I think this is pretty hard in 5.0 but I would ask Terry - maybe he's
done something for 5.0.

The "running a report without clicking" is an enhancement I coded for
6.0 Infomaker but didn't get in at the last minute. It would require
modification of the w_pbstyle_frame_ancestor in IMSTYLE6.PBL to capture
the parameters you send in.

Terry Dykstra also has a report scheduler that he's written - you might
want to check with him also. My code for IM 6.0 only runs them
unattended like:

myexe /r report_name // run only
myexe /rp report_name // run and print
myexe /p my_pipeline // run a deployed pipeline

One of the good things about 6.0 is we took the styles out of the
PBTYP050.DLL and placed them in a regular PBL (IMSTYLE6.PBL). If you're
a Powerbuilder developer, you can customize the template (menus,
scripting) used to build the executables for your own organization by
modifying IMSTYLE6.PBL

There are a lot of features in 6.0 that help the end user.
1. Hidden reports (so dddw edits styles and nested reports can be
hidden in the "Open Report" dialog if you don't want these run
separately.)
2. Query Governor (#rows and time limit) for runtime exes.
3. Open Report/Form/Pipeline dialog has comments

Report_name1 Comment from Environment painter
Report_name2 Comment from Environment painter 2

so users can more easily pick a report by description than having to
name a report "sales_for_1997_report".

3a. Only get Open Report/Form/Pipeline icons/menu picks if you've
created the executable with one of these objects. In 3.0-5.0, you'd
always get an "Open Form" button, for instance, even if your exe had
only reports. It would bring up a blank dialog and confuse the user.

4. Deployable pipelines. It's not in the "What's New" screen but it
should be in the documentation. We created a window to run pipelines in
the deployed executable. This window also has "timed" pipelines for
delayed and delayed/recurring execution (every hour/day,etc). This
allows you to connect to databases with NATIVE drivers and pipe down to
ODBC, for instance, for small change.

5. Lots of prompts "Changes, do you want to save?" type of questions in
forms - an area that was lacking in the past. Lots of small user
interface things fixed in forms. Sort/Filter dialogs - even in 12many
and many21 forms for BOTH master and detail.

6. More consistent menus between development and runtime - esp the form
menus where we didn't even have File/Exit.

7. Help/About will now allow you do identify yourself, email, web
address, etc as the developer. You can place version and other software
info on this screen and a company logo in BMP format. It isn't as good
as I would have liked but it's better than the old "Powerlauncher"
screen we had before and delivers a more professional looking exe.

8. Runtime 'print options' dialog for reports to print, say pages 2,3 of
a 100 page report. One of the things most customers asked for.

I also coded something for forms that places the comments for each
column (from the database) in the microhelp as you tab from column to
column. This might get into 6.0.01. We were trying to make the exe
more professional looking and I think it turned out pretty well.

I hope you'll look into IM 6.0.

Stephen Dupre
Powersoft Tools


Terry Dykstra [TeamPS] Posted on 1998-01-13 18:03:16.0Z
Newsgroups: sybase.public.infomaker.general
From: "Terry Dykstra [TeamPS]" <tdykstra@cfol.ab.ca>
Subject: Re: SQL/Parameter Passing
Organization: Canadian Forest Oil Ltd.
X-Newsreader: Microsoft Internet News 4.70.1161
Date: Tue, 13 Jan 1998 13:03:16 -0500
Lines: 115
Message-ID: <348_01bd2056$95dff280$8366e4cf@tdykstra.cfol.ab.ca>
References: <348_34BAAF6A.EAC725F5@coynet.com> <348_34BB926E.751F@powersoft.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.powersoft.com
Xref: forums-1-dub sybase.public.infomaker.general:7321
Article PK: 244378

My program requires PB. It uses PBD's that contain all the IM reports
developed by the users. As parameters it takes the Oracle servername,
report name, action_code (print, save, screen or a combination of these),
and report parameters. You don't have to send all parameters. In that
case it will prompt only for the missing ones.

--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Stephen Dupre[Powersoft Tools, Sybase, Inc.] <sdupre@powersoft.com> wrote
in article <34BB926E.751F@powersoft.com>...
> Mike Hyslop wrote:
> >
> > I would like to create an executable report with Infomaker 5.0 and be
> > able to call that executable from other programs. The question is:
> >
> > Is it possible to pass parameters with that call?
> >
> > Preferably I would like to send SQL scripts, but I'd settle for being
> > able to pass the name of a pregenerated report and just bypass any
> > further button clicking on the default toolbar.
> >
> > Anyone else tried this before?
> >
> > Mike Hyslop
>
> I think this is pretty hard in 5.0 but I would ask Terry - maybe he's
> done something for 5.0.
>
> The "running a report without clicking" is an enhancement I coded for
> 6.0 Infomaker but didn't get in at the last minute. It would require
> modification of the w_pbstyle_frame_ancestor in IMSTYLE6.PBL to capture
> the parameters you send in.
>
> Terry Dykstra also has a report scheduler that he's written - you might
> want to check with him also. My code for IM 6.0 only runs them
> unattended like:
>
> myexe /r report_name // run only
> myexe /rp report_name // run and print
> myexe /p my_pipeline // run a deployed pipeline
>
> One of the good things about 6.0 is we took the styles out of the
> PBTYP050.DLL and placed them in a regular PBL (IMSTYLE6.PBL). If you're
> a Powerbuilder developer, you can customize the template (menus,
> scripting) used to build the executables for your own organization by
> modifying IMSTYLE6.PBL
>
> There are a lot of features in 6.0 that help the end user.
> 1. Hidden reports (so dddw edits styles and nested reports can be
> hidden in the "Open Report" dialog if you don't want these run
> separately.)
> 2. Query Governor (#rows and time limit) for runtime exes.
> 3. Open Report/Form/Pipeline dialog has comments
>
> Report_name1 Comment from Environment painter
> Report_name2 Comment from Environment painter 2
>
> so users can more easily pick a report by description than having to
> name a report "sales_for_1997_report".
>
> 3a. Only get Open Report/Form/Pipeline icons/menu picks if you've
> created the executable with one of these objects. In 3.0-5.0, you'd
> always get an "Open Form" button, for instance, even if your exe had
> only reports. It would bring up a blank dialog and confuse the user.
>
> 4. Deployable pipelines. It's not in the "What's New" screen but it
> should be in the documentation. We created a window to run pipelines in
> the deployed executable. This window also has "timed" pipelines for
> delayed and delayed/recurring execution (every hour/day,etc). This
> allows you to connect to databases with NATIVE drivers and pipe down to
> ODBC, for instance, for small change.
>
> 5. Lots of prompts "Changes, do you want to save?" type of questions in
> forms - an area that was lacking in the past. Lots of small user
> interface things fixed in forms. Sort/Filter dialogs - even in 12many
> and many21 forms for BOTH master and detail.
>
> 6. More consistent menus between development and runtime - esp the form
> menus where we didn't even have File/Exit.
>
> 7. Help/About will now allow you do identify yourself, email, web
> address, etc as the developer. You can place version and other software
> info on this screen and a company logo in BMP format. It isn't as good
> as I would have liked but it's better than the old "Powerlauncher"
> screen we had before and delivers a more professional looking exe.
>
> 8. Runtime 'print options' dialog for reports to print, say pages 2,3 of
> a 100 page report. One of the things most customers asked for.
>
> I also coded something for forms that places the comments for each
> column (from the database) in the microhelp as you tab from column to
> column. This might get into 6.0.01. We were trying to make the exe
> more professional looking and I think it turned out pretty well.
>
> I hope you'll look into IM 6.0.
>
> Stephen Dupre
> Powersoft Tools
>