Hi, Frank We had a major discussion on this topic in ProFox many years ago, and I tend to assume that everybody was here for it. Sorry.
From the time I moved to VFP from FP2.6, my inflexible rule is never, NEVER, diddle with the database in a form. My form is a User Interface, nothing more, and its function is to show fields to the user and receive instructions from him/her. When I get a directive from the user (e.g., Click() on a button), that button calls a procedure in the program that does whatever needs done. More and more often now that 'procedure' is a method of a business object. In other words, it's an n-tier system, UI is one of the tiers, and it does NOT worry its pretty head about data structures or indexes. Another advantage is that my forms are smaller, simpler, and faster. Dan On 01/31/12 17:03, Frank Cazabon wrote: > Dan, > You don't use sql in your forms? Why not? > > On 31 Jan 2012 20:13, "Dan Covill"<dcov...@san.rr.com> wrote: > > John: > > The main gotcha I know of in going from 7 to 9 is in the SQL logic, > which is unlikely to appear in a form method. So you should be able to > twiddle the form in VFP9, then run it in 7, so long as you don't use any > of the VFP9-specific enhancements. > > FWIW, the longer I work with 9, the quicker I am to convert to using it. > The SQL logic is the only place I've ever had to do any real work, and > 9 is faster and neater. Replace the run-times and your in business. > > Dan _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4f28d339.1090...@san.rr.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
