Peter,
This is more of an SQL question and what you have to do depends on what you're, umm, trying to do. For example, if you just want the list to start with the item identified by the search term (and you're sorting by that term) and you don't need to "page up", change your query so you return all records where the search value >= key field (or just equal to if you only want to show matching records). This would make the result set start with the search term. On the other hand, if you just want to position to the record and still be able to page up, you'll have to examine the query results and figure out which page of data to display.
The second way is possible but most web applications don't work that way and you want your web applications to be like most other web applications unless you have a very, very good reason (backed up with usability testing) to do something different. My guess would be that making it work like other web applications is not going to be a problem for people used to the green screen way.
Also, this is one of those times where Net.Data's syntax starts getting in the way of doing what you want. If you do this, I would write a program to do this and let Net.Data call the program. A program can create a Net.Data table object (or several of them) and you can process it just like query results. I think there are examples of these types of programs on the Ignite/400 if not, let me know and I'll dig something up.
One other thing to be aware of: if Net.Data has to start dealing with large result sets (both number of rows and size of the rows), it gets very slow very quickly.
Matt
-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Peter Vidal
Sent: Friday, April 25, 2008 4:06 PM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Doing subfiles in Net.Data
Now that I am using
http://www.ignite400.org/html/macro_examples.htm as a
good example to do a "subfile", I have another need. I need to manipulate
the program so I can use a "POSITION TO" field that will help me
re-position the list to that item that I am looking for.
In other words, I currently have a list of 1,349 items in the file I am
displaying, with a page size of 15. However, I want to search for an item
(that is record #800) and I want to enter the value in a box. Then, after
clicking on a POSITION TO or SEARCH button, I want the screen to display
the item in the first potion of that page and all of the others
following...
How can I do this?
TIA,
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
"The ability to focus attention on important things is a defining
characteristic of intelligence."
Robert J. Shiller, Irrational Exuberance
--------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------
midrange.com
