Subject |
Filter problem |
From |
Charlie <tm@tc.com> |
Date |
Fri, 28 Mar 2025 17:05:55 -0400 |
Newsgroups |
dbase.getting-started |
I am having a problem filtering this. I've tried different attempts including params with no luck.
sql
this.COLLECTION6 = new QUERY(this)
with (this.COLLECTION6)
left = 448.0
width = 64.0
height = 37.0
database = form.coindata1
sql = "SELECT SUM(qty * estv) AS catval FROM COLLECTION"
active = true
endwith
variable:
fltr = trim(form.category1.rowset.fields["cat"].value)
one of several attempts at a filter:
form.collection6.rowset.filter = [category ='] + fltr + [']
form.entryfield6.value = form.collection6.rowset.fields["catval"].value
This gives me 'undefined: category'
Any help would be appreciated!
|
|