Subject: | Re: filter
| Date: | 13 Aug 2021 14:34:41 -0400
| From: | "Kevin Zawicki" <numberjack@wi.rr.com>
| Newsgroups: | pnews.paradox-development
|
use tcursor with setgenfilter
Steve Green <steve@oasistradingpost.com> wrote:
>trying something new.. menuAction(menuFormFilter) on a pushbutton will
>open the generic filter dialog, on the current table frame on a form..
>entering and changing field parameters, filtering the table, works fine
>
>thought it would be a nice simple way to give them access to some log
>tables without having to build an interface using SetGenFilter
>
>here's the problem.. getting rid of the filters when I close the form..
>if I don't clear them, they're still there next time the form opens, and
>in theory, every time the app writes to the log table?
>
>tried attaching to the table frame with a uiobject, clearing each field
>with a setrange().. tried opening a tcursor, clearing each field with a
>setrange().. both times Paradox said no.. what am I missing?
>
>
>var
>u uiobject
>endvar
>
>u.attach("userlog") ; the table frame
>
>u.user.setrange()
>u.date_changed.setrange()
>u.time_changed.setrange()
>u.process.setrange()
>u.action.setrange()
>
>"the referenced object (user) could not be found"
>
>- or -
>
>var
>tc tcursor
>endvar
>
>tc.open("userlog.db") ; the actual table
>
>tc.user.setrange()
>tc.date_changed.setrange()
>tc.time_changed.setrange()
>tc.process.setrange()
>tc.action.setrange()
>
>"the method is not valid for the object (user)" ??
>
>--
>Steven Green
>Myrtle Beach, South Carolina USA
>
>http://www.OasisTradingPost.com
>
>Collectibles and Memorabilia
>Vintage Lego Sets and Parts
>- and Paradox support, too
|