Ah, all my systems are n-tier too, but I still make use of sql commands against the local cursors for various aspects of the ui, such as totaling invoice details during editing and so on.
I'm also a relative newbie here on profox and do not recall that discussion. On 1 Feb 2012 01:52, "Dan Covill" <dcov...@san.rr.com> wrote: 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 ... _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: htt... 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 cons... Report [OT] Abuse: http://leafe.com/reportAbuse/4f28d339.1090...@san.rr.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ 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/CAHEe=u4yi9_5nmmm6fctdtdqsd-oofq6gf5jdhhtukeq6l2...@mail.gmail.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.
