× 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.



Great article Jon.  I like the idea of the array for the data structure!   Much better than what I have been doing.

One other practice I have adopted with subfiles is to focus on making them entirely mousable, which means no option field.  Each subfile row is 75 or 125 characters long and is populated with a datastructure with the edited data to be displayed.  The advantage is that each subfile row can be a check box field (with no visible check box) and thus one can select/unselect  1 to many rows then process each selected row, one after the other.  Because the option field options have been moved to the details screen one can still process edit, copy, delete, and refresh easily. Add filters, sortable columns, and a scroll bar and suddenly the 1980s green screen has modern function and patterns.   Plus, once all sorted out, it really is about as simple a complete subfile process as I have ever seen.

Guess it's time to re-write my 2015 demo <http://www.martinvt.com/SQL_-simple-/SQL_Simple_Subfile/sql_simple_subfile.html> ...

On 2/2/2020 10:48 AM, Jon Paris wrote:
I documented the latest incarnation of the standard technique I have been using for many years here:https://www.itjungle.com/2015/03/03/fhg030315-story01/

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.