This is the first submission in a series of methodologies that I'll submit for creating record browsers in a fairly modular way using WebSpeed.

The basic idea is that using browsedefs.i, you can make one or more record browsers on any given webpage. Each of the browsers has previous and next page buttons, and page numbers so that you can move to any spot in the result set.

You can make certain of the columns sortable.

Another nifty feature of this particular model is that the query for producing the record set is 100% dynamic, although it is fully compatible with WebSpeed 2.1. In other words, it writes a procedure file based on the dynamic query, and executes it at run-time.

Perhaps others would like to take this code and try to make a version that will utilize the Version 9/3 dynamic query 4gl..

Note that much like the dynamic query stuff in version 9/3, you cannot use variables in the query - you have to resolve them to their constant values prior to preparing your query.

To Install:

• Place browse*.html files in a directory in your propath called "include". (You can change this later)
• Place browsedefs.i in a directory in your propath called "lib".
• Using the WebSpeed Workshop file tools, compile all of the .html files in your "include" directory into .i files.
• Create a "/ff" subdirectory in your webserver's root directory (or make a virtual directory), and place the freestyle.css file in it. (You can move this later, or change the path and stylesheet in your brws_example.html file)
• Take the brws_example.html file, and customize it to fit a table in one of your own databases. The code is self documented.

The code is self documented, so have fun!

For questions or comments, contact the author, Steve Southwell: ses@usiatl.com