Paradox Community

Items in pnews.paradox-development

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


Copyright © 2004 thedbcommunity.com