×
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.
what does the programmer have to do to select, add,
update, and delete records?
First, what does the user have to do?
Select row(s)?
Click, shift-click, ctrl-click. Or, with the keyboard, arrow up, arrow down, home, end, shift + arrow keys to select multiple rows. Shift-End to select remaining rows. Ctrl-A to select all rows.
Add mode?
Click the "Add" link or press F6.
Change mode?
Click the "Change" link or press F2.
Delete mode?
Select row(s) then click the "Delete" link or press the delete key.
What does the programmer have to do?
Needs to include a reference to the JavaScript file in the HTML template that implements those behaviors.
How flexible is it?
Programmer has full control by modifying HTML templates and JavaScript.
How you override the behavior?
Normally by modifying HTML templates and JavaScript. Possibly using exit-points in the server framework.
PAGING?
PgUp and PgDn work, but I prefer appending rows to the list asynchronously, triggered by a UI event. Or filtering the list.
SORTING?
UI event triggers a change to an SQL order by clause, which may include multiple fields and SQL functions, then refresh the result set.
VALIDATION?
The framework calls a customized procedure to validate fields and return error messages.
FIELD LEVEL SECURITY?
We define options like this in a repository on the server and write code to conditionally output stuff based on user defined privileges. We use the same framework for all our applications.
-Nathan
midrange.com
