Paradox Community

Items in pnews.paradox-development

Subject:filter
Date:Thu, 12 Aug 2021 11:45:17 -0400
From:Steve Green <steve@oasistradingpost.com>
Newsgroups:pnews.paradox-development
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