×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
I'm interested in hearing your thoughts about using a "worksheet" for database inquiry and maintenance, where each "cell" in a worksheet represents a "record" in a database table. We're just beginning to implement a worksheet model for viewing and entering grades & scores on student assignments. See the screen-shot:
http://www.radile.com/rdweb/temp/worksheet.pdf
In this example, worksheet data comes from three (3) related tables or SQL views - Students, Assignments, and Grades; where grades may be entered and maintained, using a worksheet format. Actually the record may contain more than one field, which are displayed in a popup when the F2=Change key is pressed.
My question is, what other types of inquiry & maintenance applications might the worksheet metaphor might apply to? Can you come up with other use cases?
We're implementing a fair amount of JavaScript to support worksheet navigation, horizontal and vertical scrolling, individual and block cell selection, auto fill, and editing.
I'm considering structuring the browser and server components in a manner that would make them more reusable - adaptable to other use cases. That might make sense, if there are enough potential use cases.
My gut feel is that a Worksheet model could be applied to different types of applications - but that's mostly based on the fact that so many people seem interested in transferring IBM i data to Excel, and back again. What are some use cases?
Thank's for you thoughts,
-Nathan.
midrange.com
