How about using SQL in your Net.Data macro? You can create an HTML page
with the text boxes (or radio buttons, drop downs, etc) asking the user for
the required filters and then use that to run your SQL. We have been doing
this for years, and it works well. If you would like to see it in action,
go to www.leonhenryinc.com then select Management from the menu at the top,
and Data Cards from the list that is displayed. This will call a Net.Data
macro that asks for program type and subtype, category, and/or name, and
then display a list of those records in the database that meet the criteria.
Larry Kleinman
Kleinman Associates, Inc.
212-949-6469
203-255-4100
Peter_Vidal@pall.
com
Sent by: To
web400-bounces@mi Web Enabling the AS400 / iSeries
drange.com <web400@xxxxxxxxxxxx>
cc
02/02/2009 12:23 Subject
PM Re: [WEB400] Net.Data and data
filters
Please respond to
Web Enabling the
AS400 / iSeries
<web400@midrange.
com>
"How often is the 173000 record file updated, is it at any time or is it
an extract file that is created perhaps once a day?"
===>The file is refreshed once a day (7:00AM)
"How many columns does the file have and what is the approx total size (
in MB ) on disk?"
===>Resides on the iSeries, it will have approx 20MB and 9 pair of
elements, meaning that I need 18 filters.
Would you consider using a technology other than RPG ( which you say you
don't want to use ) and net.data?
===>We can't go there for the moment.
Even if that solution was Microsoft ASP.NET and the solution ( plus the
coding ) was provided FOC?"
===>We do not have local programmers that are exposed to ASp.NET... yet.
Thanks for your help Maurice!
PETER VIDAL
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
WWW.PALL.COM
"A mind troubled by doubt cannot focus on the course to victory."
Arthur Golden, Memoirs of a Geisha
--------------------------------------------------------------------------------
Attention:
This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.
--------------------------------------------------------------------------------
--
This is the Web Enabling the AS400 / iSeries (WEB400) mailing list
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/web400.
midrange.com
